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

  Which as a result of the error

Billabong Company neglected to adjust the Office Supplies (asset) account for the amount of supplies used up during the year. As a result of this error

  What is the bank balance

Bank error charged the company account for $3,750 check of another depositor. What is the bank balance on Nov. 2010

  What amount should gant report as intangible asset-franchise

What amount should Gant report as intangible asset-franchise, net of related amortization in its December 31, Year 1, balance sheet

  Journalize and post the adjusting entires

Kristin Malone opened Kristin's Maids Cleaning Service on July 1, 2017. Journalize and post the adjusting entires

  A company is contemplating investing in a new piece of

a company is contemplating investing in a new piece of manufacturing machinery. the amount to be invested is 170000.

  What is the six step process involved in valuation

What is the six step process involved in valuation? List the six steps in sequence, explaining and discusssing the importance and relevance of each step

  Discuss contrast theories of crime causation

From the e-Activity, compare and contrast theories of crime causation. Speculate as to which theory would have most likely detected fraud

  Explain how the financial statements will be affected

Explain how the financial statements will be affected if: intercompany merchandise transactions are NOT eliminated

  Calculate ingrid balance in allowance for doubtful account

Calculate Ingrid's balance in allowance for doubtful accounts on December 31, 2018, prior to the adjustment.Prepare the necessary adjusting entry for 2018.

  What will be the balance on the budgeted balance sheet

What will be the balance on the budgeted (proforma) balance sheet at 12/31/Year6 for Accounts payable to Tefco?

  Discuss does a cpa firm face an independence problem

Does a CPA firm face an independence problem in auditing the output of systems that the same firm designed and installed

  Prepare the appropriate journal entry for each transaction

Parnell Industries buys securities to be available for sale when circumstances warrant, not to profit from short-term differences in price and not necessarily.

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