Calculate the npv using excel or a financial calculator

Assignment Help Financial Accounting
Reference no: EM132940787

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

Problem 1. Calculate the payback.

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

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

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

Problem 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: EM132940787

Questions Cloud

How to manage good performance : How to manage good performance? How to manage poor performance? (in addition, discuss the 2 min challenge)
Assumptions of new employee socialization process : Write down the three steps and four assumptions of new employee socialization process.
Evaluate the firm using modigliani and miller approach : Under the Modigliani and Miller approach (Case II, Proposition I with taxes), explain how the firm can increase its value using the financial leverage?
What is the importance of organisational culture : What is the importance of organisational culture on change management strategies and does it can help or hinder a business during times of change.
Calculate the npv using excel or a financial calculator : The High Flier Corporation is a shuttle,Calculate the NPV using Excel or a Financial Calculator. Which project is the better investment? Explain your reasoning.
Business research-report writing : What are the main Tables reporting in the findings section of the thesis? detail explanation please
Determine how you believe the court should rule : Determine how you believe the court should rule. Support your decision with information from the text or other scholarly sources. Please cite outside sources.
What is one interviewing skill : What is one interviewing skill you need to improve and how will you strengthen them?
Define the term training : b. Explain any three (3)on the job training methods that are used to ensure that staff members are equipped to do their jobs.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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