Concept explainers
To calculate:
The dollar-weighted average return on monthly basis for a household saving account.
Introduction:
Dollar- weighted average return means rate of

Answer to Problem 1PS
Cash flows either positive or negative or vice versa is divided by the total of of investment,through this dollar weighted average return for a particular period can be calcualted.
Explanation of Solution
Given Information:
The saving-account of a household and entries are on the first day of each month:
Month | Additions | Withdrawls | Value |
January | |||
February | |
||
March | |
||
April | |
||
May | |
||
June | |
||
July | |
||
August | |
Household monthly Dollar Weighted Average Return can be calculated easily with the help of MS Office − Excel with the help of formulas. The calculations are shown under the snip of excel as attached below for reference:
The value of portfolio is calculated on monthly basis post taking the effects of with drawls and additions. The period of addition and with drawl in months is then converted into days to compute the weighted period and then the weighted average return is calculated.
Want to see more full solutions like this?
Chapter 18 Solutions
ESS. OF INVESTMENTS - ETEXT ACCESS CARD
- Forest Enterprises, Incorporated, has been considering the purchase of a new manufacturing facility for $290,000. The facility is to be fully depreciated on a straight-line basis over seven years. It is expected to have no resale value after the seven years. Operating revenues from the facility are expected to be $125,000, in nominal terms, at the end of the first year. The revenues are expected to increase at the inflation rate of 2 percent. Production costs at the end of the first year will be $50,000, in nominal terms, and they are expected to increase at 3 percent per year. The real discount rate is 5 percent. The corporate tax rate is 25 percent. Calculate the NPV of the project. Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. NPVarrow_forwardHelp with questionsarrow_forwardPlease help with questionsarrow_forward
- Create financial forecasting years 2022, 2023, and 2024 using this balance sheet.arrow_forwardBeta Company Ltd issued 10% perpetual debt of Rs. 1,00,000. The company's tax rate is 50%. Determine the cost of capital (before tax as well as after tax) assuming the debt is issued at 10 percent premium. helparrow_forwardFinance subject qn solve.arrow_forward
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education





