Question
A household savings-account spreadsheet shows the following entries for the first day of each month: Month Additions Withdrawals Value January 148,000 February 2,500 March 4,000
A household savings-account spreadsheet shows the following entries for the first day of each month:
| Month | Additions | Withdrawals | Value |
|---|---|---|---|
| January | 148,000 | ||
| February | 2,500 | ||
| March | 4,000 | ||
| April | 1,500 | ||
| May | 13,460 | ||
| June | 23,000 | ||
| July | 3,000 | ||
| August | 198,000 |
Required:
Use the Excel function XIRR to calculate the dollar-weighted average return for this period. (Round your answer to 2 decimal places.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Advances In Quantitative Analysis Of Finance And Accounting (Vol. 5)
Authors: Lee Cheng Few
1st Edition
9812706283, 9789812706287
