HomeworkLib
Question

Please use Excel formulas

Question 4: Given the following information regarding cash flows and discount rates, answer the questions below. Year 2 3 4 N

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

a)

Nominal rates

Year 1 = Real rate + Inflation = 2% + 4% = 6%

Year 2 = 4.5% + 1.75% = 6.25%

Year 3 = 5% + 1.5% = 6.5%

Year 4 = 5.5% + 1.25% = 6.75%

b)

Discount rates for each year is the nominal rate for each year.

c)

NPV of the project = -15000 + 5000/(1.06) + 7500/(1.0625)^2 + 3500/(1.065)^3 + 1000/(1.0675)^4 = $ 28.12

Note : There is no specific excel formula as the discount rates for each year is different and NPV formula cannot be used.

0 0
Add a comment
Know the answer?
Add Answer to:
Please use Excel formulas Question 4: Given the following information regarding cash flows and discount rates,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • Given the following information regarding cash flows and discount rates, answer the questions below. Year 0...

    Given the following information regarding cash flows and discount rates, answer the questions below. Year 0 1 2 3 4 Nominal Cash Flow -15,000 5,000 7,500 3,500 1,000 Inflation 0% 2% 1.75% 1.5% 1.25% Real Rate 0% 4% 4.5% 5% 5.5% a) What are the nominal rates for each year? b) What are the discount rates for each year? c) What is the NPV of the project?

  • Given the following information regarding cash flows and discount rates, answer the questions below. Year 0...

    Given the following information regarding cash flows and discount rates, answer the questions below. Year 0 1 2 3 4 Nominal Cash Flow -11,000 4,000 5,000 6,000 1,000 Real Rate 0% 6% 5% 4% 5% Inflation Rate 0% 3.5% 3% 2.5% 2.5% a) What are the nominal rates for each year? b) What is the NPV of the project?

  • help me with this please no excel please 15. Use the following information to answer the...

    help me with this please no excel please 15. Use the following information to answer the question below. o Year 2008 2009 2010 2011 Risk-free Return 1.75% 1.25% 1.25% 1.50% Market Return 7.50% -30.00% 9.50% 11.50% PE-Waters Return 4.50% -31.50% 6.00% 5.50% B, = 6.47826) Bez 1.048 B3:0.57577 Bu -0.4 Using the historical average excess retums and historical volatilities of both PE- Waters and Market portfolio that you can calculate from the information above. your estimate of PE-Waters' Beta is...

  • Question 3 Use an Excel spreadsheet to calculate the appropriate price and yield to maturity for...

    Question 3 Use an Excel spreadsheet to calculate the appropriate price and yield to maturity for the three bonds listed below: a. Bond with coupon rate of 10% and face value of $1000 that matures in 6 years. b. Bond with coupon rate of 5% and face value of $1000 that matures in 4 years C. Bond with coupon rate of 2% and face value of $1000 that matures in 2 years. Assume that the one-year, two-year, three-year, four-year, five-year,...

  • 4. Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0:...

    4. Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0: $468,000 Cash flow year one: $135,000 Cash flow year two: $240,000 Cash flow year three: $185,000 Cash flow year four: $135,000 Plot the NPV profile of this project in Excel. Start with discount rate equal to zero and increase the discount rate by 2% increments until discount rate equal to 30%. For what discount rates would Lepton accept this project? For what discount rates...

  • PLEASE WRITE OUT WHAT FORMULAS YOU USE 7. a. Given the cash flows in actual dollars...

    PLEASE WRITE OUT WHAT FORMULAS YOU USE 7. a. Given the cash flows in actual dollars provided in the following table, convert the cash flows to equivalent cash flows in constant dollars if the base year is time 0. Assume that the market interest rate is 16% and the general inflation rate is at 4% each year. Cash Flow (in Actual Dollars) $20,500 $41,500 $36,500 $55,500 4 Calculate the present worth value of both (actual and constant $) cashflows within...

  • Please use Excel and include all formulas in different cells so that it is clear H...

    Please use Excel and include all formulas in different cells so that it is clear H A B C D E F G 1 Northeast Hospital is analyzing a potential project for a new outpatient center Please use the following facts to create a 5-year projection of cash flow for the proposed center. Please create your full income statement first to include all cash and non-cash expenses Calculate the projects NPV, IRR, MIRR, Payback Period (not discounted). Using these calculations,...

  • *Please show all excel formulas used* Thank you! 29. Project Analysis and Inflation Earp Brothers, Inc.,...

    *Please show all excel formulas used* Thank you! 29. Project Analysis and Inflation Earp Brothers, Inc., is considering investing in a machine to produce computer keyboards. The price of the machine will be $990,000 and its economic life is five years. The machine will be fully depreciated by the straight-line method. The machine will produce 13,000 keyboards each year. The price of each keyboard will be $87 in the first year and will increase by 5 percent per year. The...

  • Use the information provided below to estimate the market value of the office building that has been described. Type of...

    Use the information provided below to estimate the market value of the office building that has been described. Type of Property: Office Building Leasable Space: 100,000 square feet Average Rent: $20.00 per square foot per year Expected Rent Growth: 4.50% per year Vacancy and Collection Losses: 15.00% of potential gross income Other Income: $1.50 per square foot per year Expected Growth in Other Income: 3.00% per year Operating Expenses: 27.50% of effective gross income Capital Expenditures: 2.50% of effective gross...

  • Use the information provided below to estimate the market value of the office building that has...

    Use the information provided below to estimate the market value of the office building that has been described. Type of Property: Office Building Leasable Space: 100,000 square feet Average Rent: $20.00 per square foot per year Expected Rent Growth: 4.50% per year Vacancy and Collection Losses: 15.00% of potential gross income Other Income: $1.50 per square foot per year Expected Growth in Other Income: 3.00% per year Operating Expenses: 27.50% of effective gross income Capital Expenditures: 2.50% of effective gross...

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