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
CONNECT WITH LEARNSMART FOR BODIE: ESSE
- After many sunset viewings at SUNY Brockport, Amanda dreams of owning a waterfront home on Lake Ontario. She finds her perfect house listed at $425,000. Leveraging the negotiation skills she developed at school, she persuades the seller to drop the price to $405,000. What would be her annual payment if she opts for a 30-year mortgage from Five Star Bank with an interest rate of 14.95% and no down payment? a- $25,938 b- $26,196 c- $24,500 d- $27,000arrow_forwardImagine that the SUNY Brockport Student Government Association (SGA) is considering investing in sustainable campus improvements. These improvements include installing solar panels, updating campus lighting to energy-efficient LEDs, and implementing a rainwater collection system for irrigation. The total initial investment required for these projects is $100,000. The projects are expected to generate savings (effectively, the cash inflows in this scenario) of $30,000 in the first year, $40,000 in the second year, $50,000 in the third year, and $60,000 in the fourth year due to reduced energy and maintenance costs. SUNY Brockport’s discount rate is 8%. What is the NPV of the sustainable campus improvements? (rounded) a- $70,213b- $48,729c- $45,865d- $62,040arrow_forwardImagine that the SUNY Brockport Student Government Association (SGA) is considering investing in sustainable campus improvements. These improvements include installing solar panels, updating campus lighting to energy-efficient LEDs, and implementing a rainwater collection system for irrigation. The total initial investment required for these projects is $100,000. The projects are expected to generate savings (effectively, the cash inflows in this scenario) of $30,000 in the first year, $40,000 in the second year, $50,000 in the third year, and $60,000 in the fourth year due to reduced energy and maintenance costs. SUNY Brockport’s discount rate is 8%. What is the NPV of the sustainable campus improvements? (rounded)a- $70,213b- $48,729c- $45,865d- $62,040arrow_forward
- After many sunset viewings at SUNY Brockport, Amanda dreams of owning a waterfront home on Lake Ontario. She finds her perfect house listed at $425,000. Leveraging the negotiation skills she developed at school, she persuades the seller to drop the price to $405,000. What would be her annual payment if she opts for a 30-year mortgage from Five Star Bank with an interest rate of 14.95% and no down payment? 26,196 27,000 24,500 25,938arrow_forwardWhat is an amortized loan?arrow_forwardWhat is the difference between stakeholders and stockholders?arrow_forward
- What are the three general forms of business organization?arrow_forwardWhy should we care about the difference between book value and market value?arrow_forward1. A bond currently has a price of $1,050. The yield on the bond is 5%. If the yield increases 30 basis points, the price of the bond will go down to $1,035. The duration of this bond is closest to: Group of answer choices None of the above 6.0 5 4.5 5.5 2. A callable corporate bond can be purchased by the bond issuer before maturity for a price specified at the time the bond is issued. Corporation X issues two bonds (bond A and bond B) at the same time with thesame maturity, par value, and coupons. However, bond A is callable and bond B is not. Which bond will sell for a higher price and why? Group of answer choices Bond B; bond B should have the value of bond A minus the value of the call option Bond A; bond A should have the value of bond B plus the value of the call option Not enough information Bond A; bond A should have the value of bond B minus the value of the call option Bond B; bond B should have the value of bond A plus the value of the call optionarrow_forward
- In plain English, what is the Agency problem?arrow_forwardHW Question 29: what is the difference between accounting and finance?arrow_forward1. You are assessing the average performance of two mutual fund managers with the Fama-French 3-factor model. The fund managers and the Fama-French factors had the following performance over this periodof time: Manager 1 Manager 2 Rm − rf smb hmlAvg. (total) Ret 27% 13% 8% 2% 6%βmkt 2 1 1 0 0s 1 -0.5 0 1 0h 1 0.5 0 0 1 The risk-free rate is 2%. What kinds of stocks does Manager 1 invest in? Group of answer choices Small-cap value stocks Large-cap value stocks Large-cap growth stocks Not enough information…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





