Calculate the NPV using Excel or a Financial Calculator

Assignment Help Accounting Basics
Reference no: EM133025534

Question - The High Flier Corporation is a shuttle service that provides transportation from Provo, Utah to the Salt Lake City Airport. Currently the company uses one van that can transport up to six people at a time. The owner of the business is considering the purchase of a bigger van that could transport more people and would also have more room for luggage and ski equipment. He has determined that he can invest $135,000 in a used van that would last about three years, or he could invest in new van that would provide a useful life of five years. The used van is larger than the existing van and the new van, but would not last as long as the new van. The new van would result in $230K in cash flows over 5 years, while the used van would result in $185K in cash flows over 3 years. Use a discount rate of 9%.

Assume the following information for High Flier Corporation: A $135,000 investment yields the following inflows of cash:

Year 1 Investment A 70000 Investment B 28000

Year 2 Investment A 70000 Investment B 32000

Year 3 Investment A 45000 Investment B 45000

Year 4 Investment A Investment B 55000

Year 5 Investment A Investment B 70000

Using the information above, do the following

1. Calculate the payback.

2. Calculate the NPV using Excel or a Financial Calculator.

3. Calculate the IRR using Excel or a Financial Calculator.

4. Which project is the better investment? Explain your reasoning.

5. Compare and contrast the use of the NPV versus the IRR for evaluating a project. What are the limitations of each method?

Reference no: EM133025534

Questions Cloud

What amount should Blossom Company pay for this investment : Blossom Company is considering investing in an annuity contract that will return $26,000 annually. What amount should Blossom Company pay for this investment
Mobile applications vs websites : Compare and Contrast mobile applications vs websites. Research and discuss the importance of developing a mobile strategy.
Implications of the best fit convention : Consider the implications of the "best fit" convention and provide suggestions for its use
Data mining different from database : How is a data mining different from a database? Define what is the data preprocessing and explain four steps.
Calculate the NPV using Excel or a Financial Calculator : The new van would result in $230K in cash flows over 5 years, while the used van would result in $185K in cash. Calculate the NPV using Excel
Discuss how you have applied international law : Explain and discuss how you have applied international law in your resolution. Account for the political reasoning behind the resolution's
What is the value of process : Review the NLRB Unfair Labor Practice (ULP) process. What is the value of this process? How does it compare to processes in non-union environments?
Impacting the human resource function : How do you see an organization's compliance with labor laws impacting the human resource function?
Calculate Firm M average total assets : Firm M has a margin of 7%, turnover of 1.5, sales of $990,000, and average stockholders' equity of $450,000. Calculate Firm M's average total assets

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd