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:
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
22. Given the cash flows below, answer the following question (provide your answer and show your...
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 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 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 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 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 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 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 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 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: 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...