Question

22. Given the cash flows below, answer the following question (provide your answer and show your...

22. Given the cash flows below, answer the following question (provide your answer and show your work in your uploaded document) (maximum points: 3.33)

                                    Date                Cash Flow       Balance

                                    7/1                      Begin            2,150

                                    7/31                    ------              2,280

                                    8/1                      $180             2,460

                                    8/31                    ------              2,561

                                    9/1                      $100             2,661

                                    9/30                 End               2,500

Calculate the average monthly rate of return using the money (dollar)-weighted method over the three months provided here (round your answer to 3 decimals in the form 0.000) Show your work in the uploaded document:

0 0
Add a comment Improve this question Transcribed image text
Answer #1
Date balances money weighted return
7/1 2150
7/31 2280 =2150/2280=0.943
8/1 2460
8/31 2561 =2460/2561=0.960
9/1 2661
9/30 2500 =2661/2500=1.064

Average monthly retrun for 3 months is = ( 0.943+0.960+1.064 )/3

= 0.989

Add a comment
Know the answer?
Add Answer to:
22. Given the cash flows below, answer the following question (provide your answer and show your...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 21. Given the cash flows below, answer the following question (provide your answer and show work...

    21. Given the cash flows below, answer the following question (provide your answer and show work in your uploaded document) (maximum points: 3.33)                                     Date                Cash Flow       Balance                                     7/1                      Begin            2,150                                     7/31                    ------              2,280                                     8/1                      $180             2,460                                     8/31                    ------              2,561                                     9/1                      $100             2,661                                     9/30                 End               2,500 Calculate the average monthly percent rate of return using the time-weighted method over the three months provided here round your answer to 3...

  • Consider the following cash flows (see the attached Excel sheet) and answer the following questions. Show...

    Consider the following cash flows (see the attached Excel sheet) and answer the following questions. Show your work in Excel. a) What is the net present value (NPV) if the opportunity cost of cost of capital is 10%? b) Add an outflow of $2000 at time 0 and lower the opportunity cost of capital to 6%. Now, what is the net present value? B A Parta) Year Cash Flow $2,000 $2,000 $1,500 $2,500 $4,000 5 Cost of Capit 10% NPV...

  • Show your work please. Problem 3 [1 point]: The free cash flows (in millions) shown below...

    Show your work please. Problem 3 [1 point]: The free cash flows (in millions) shown below are forecast by Simmons Inc. If the weighted average cost of capital is 13% and the free cash flows are expected to continue growing at the same rate after Year 3 as from Year 2 to Year 3, what is the Year 0 value of operations, in millions? Year: 1 2 3 -------------------------------------------------------- Free cash flow: -$20 $42    $45

  • An examination of the cash activities during the year shows the following. Date 7/1 7/15 7/22...

    An examination of the cash activities during the year shows the following. Date 7/1 7/15 7/22 7/30 8/1 8/10 8/17 9/21 10/17 12/15 GREAT ADVENTURES Cash Account Records July 1, 2021, to December 31, 2021 Cash Receipts Cash Disbursements Desc. Amount Date Check# Desc. Stock sale $ 30,000 7/1 101 Insurance clinic receipts 1,800 7/2 102 Legal fees clinic receipts 2,760 7/7 DC Advertising clinic receipts 3,600 7/8 103 Bikes Borrowing 29,000 7/24 Advertising clinic receipts 5,100 8/4 104 Kayaks...

  • Consider the following cash flows (see the attached Excel sheet) and answer the following questions.(see attached...

    Consider the following cash flows (see the attached Excel sheet) and answer the following questions.(see attached pic) a) What is the net present value (NPV) if the opportunity cost of cost of capital is 10%? b) Add an outflow of $2000 at time 0 and lower the opportunity cost of capital to 6%. Now, what is the net present value? M N O 1 Parta) 2 Year Cash Flow 0 $ 2,000 1 $ 2,000 2 $ 3 $ 1,500...

  • 4. Given the following dataset: 7, 4, 7, 9, 3 a. What is the mean? Show...

    4. Given the following dataset: 7, 4, 7, 9, 3 a. What is the mean? Show your work. (1 point) 9+7+7+4+3 = 30                     30/5 = 6                       Thus, the mean is 6 b. What is the standard deviation? Use the table below to help. Round to 2 decimals. (2 points) X -   M = Deviations (x-M) Squared Deviations (x-M)2 7 - 6 = 1 1 4 -6 = -2 4 7 -6 = 1 1 9 -6 = 3 9...

  • Suppose your firm is considering investing in a project with the cash flows shown below, that...

    Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 7 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: 0 1 2 3 4 5 6 Cash flow: –$5,300 $1,300 $2,500 $1,700 $1,700 $1,500 $1,300 Use the discounted payback decision rule to evaluate this project. (Round your answer to...

  • With interest rate 7%, calculate the PV of following cash flows. Answer the following questions. SHOW...

    With interest rate 7%, calculate the PV of following cash flows. Answer the following questions. SHOW ALL WORK please 1A. What is PV in year 2? 1B.what is the PV in year 4? Year Payment PV 2 3 4 5 1,000 1,000 1,000 1,000 1,000

  • QUESTION 1 A Statement of Cash Flows is generated to show: a. How profits were generated...

    QUESTION 1 A Statement of Cash Flows is generated to show: a. How profits were generated during the period. b. The revenues the company has earned during the period. c. The inflow and outflow of cash during the period. d. The expenses the company incurred during the period. 1 points    QUESTION 2 Smithson Corp. had the following selected balance sheet changes for the past year: Assets Increase (Decrease) Cash $47,000 Accounts Receivable $10,000 Inventory $15,000 Prepaid Expenses ($7,000) Accumulated...

  • 1. You have the chance to participate in a project that produces the following cash flows:...

    1. You have the chance to participate in a project that produces the following cash flows: Cash Flows ($) C0 C1 C2 4,600 4,400 –10,800 a. The internal rate of return is 12.69%. If the opportunity cost of capital is 12%, what is the NPV of the project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 2 decimal places.) NPV            $ __________. 2. Consider the following projects: Cash Flows...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT