Question

Borrow lump sum of 250000 and repay in 7 year annual installments. EAR 4.04% 0 250,000...

Borrow lump sum of 250000 and repay in 7 year annual installments. EAR 4.04%

0 250,000

ANNUAL CASH FLOW

1 25000

2 50000

3 75000

4

5

6

7

What is the NPV of year 0-3 cash flow and FV of NPV in 3 years.

I am having a hard time setting up this question, I knwo the last four payments will be equal amounts of $35,147. Please help.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Year Cash Flow PV

0 -250000 -250000.00

1 25000 24029.21953

2 50000 46192.2713

3 75000 66597.85366

4 Total -113180.66

5

6

7

NPV of year 0-3 cash flows -113180.66

FV of NPV after 3 years -127459.80 113180.66*(1+4.04%)^3

Equal payments $35,147

Add a comment
Know the answer?
Add Answer to:
Borrow lump sum of 250000 and repay in 7 year annual installments. EAR 4.04% 0 250,000...
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
  • Please fill in the blanks. Net Present Value Calculation Year 0 Year 1 Year 2 Year...

    Please fill in the blanks. Net Present Value Calculation Year 0 Year 1 Year 2 Year 3 NCO -100000 Annual Cash 20000 25000 30000 Residual Cash 70000 Required Rtn Cash Flow 12% 12% 12% Req Rtn, Residual 15% PV Mid-year Factors 0.57 1.62 2.68 Present Values _____ _____ _____ _____ PV Residual _____ NPV _____ Formula: FV/(1+$TV)^N = PV Internal Rate of Return Calculation Year 0 Year 1 Year 2 Year 3 NCO _____ Annual Cash _____ _____ _____ Residual...

  • *First, what is the annual operating cash flow of the project for year 1? *What is...

    *First, what is the annual operating cash flow of the project for year 1? *What is the annual operating cash flow of the project for year 2? *What is the annual operating cash flow of the project for year 3? *What is the annual operating cash flow of the project for year 4? *What is the annual operating cash flow of the project for year 5? *Next, what is the after-tax cash flow of the equipment at disposal? *Then, what...

  • 5 Consider the investment project with the following net cash flows: Year Net Cash Flow 0...

    5 Consider the investment project with the following net cash flows: Year Net Cash Flow 0 $1,500 SX $650 SX What would be the value of X if the project's IRR is known to be 10%? The annual income from a rented house is $24,000. The annual expenses are $6000. If the house can be sold for $245,000 at the end of 10 years, how much could you afford to pay for it now, if you considered 900 to be...

  • Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question...

    Time Value of Money Spreadsheet Example 4 Module IV Name: Date: 6 7 8 Question 1 9 Question 2 10 Question 3 11 Question 4 12 Question 5 13 Question 6 14 Question 7 15 Question 8 16 Question 9 17 Question 10 18 19 20 Single Amount or Annuity 21 Periodic Interest Rate 22 Number of Periods 23 24 25 Present Value of Single Amount 26 27 Future Value of Single Amount 28 29 Future Value of An Annuity...

  • I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value...

    I need help on question 2. MODULE IV: TIME VALUE OF MONEY INTRODUCTION The time value of money analysis has many a lysis has many applications, ranging from setting hedules for paying off loans to decisions about whether to invest in a partie financial instrument. First, let's define the following notations: I = the interest rate per period Na the total number of payment periods in an annuity PMT = the annuity payment made each period PV = present value...

  • Show your work as much as possible below each question to get full credit (Le, you...

    Show your work as much as possible below each question to get full credit (Le, you should provide information about PV: FV. PMT, I/Y, N ... before writing down your answer) 1. What is the present value of the following cash flow stream at a rate of 8.0%? Years: CFs: $2,450 $3,175 $4,400 2. You would like to travel in South America 5 years from now, and you can save $3,100 per year, beginning one year from today. You plan...

  • I need you to work this assignment out using excel. It will be a huge help to me. Thanks.

    I need you to work this assignment out using excel. It will be a huge help to me. Thanks. The ABC Project 1 3 The ABC Company currently markets its chocalate and other related products. 4While seeking expansion ideas, management of the company decided to look into the possibility of a line of the new product. 5 Entry into this business would require the purchase of an existing 50-acre land in Atalanta GA at a cost of $250,000 for the...

  • 7 parts reminaing must do all the way until year 6 thank you an example of what its supposed to look like...

    7 parts reminaing must do all the way until year 6 thank you an example of what its supposed to look like After spending $10.100 on client-development you have just been offered a big production contract by a new clent The contract will add $191,000 to your revenues for each of the next five years and it will cost you $95,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment...

  • Knowledge Check 01 A friend asks to borrow $635.52 today and promises to repay you $1,000...

    Knowledge Check 01 A friend asks to borrow $635.52 today and promises to repay you $1,000 with interest compounded annually at 12%. How many years (compounding periods) will pass before you receive the payment? (FV of $1. PV of $1. EVA of $1. PVA of $1. EVAD of S1 and PVAD of S1) (Use appropriate factor(s) from the tables provided. Round your final answer to the nearest whole year.) Number of years TABLE 1 Future Value of $1 FV =...

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