Sensitivity Analysis: using excel

Sensitivity Analysis: using excel
Lane Construction ltd. is considering the acquisition of a new eighteen wheeler.
-The truck base price is $80,000 and it will cost another $20,000 to modify it for special use by the company.
-This truck falls into MACRS five year class. It will be sold after three years for $30,000.
-The truck purchase will have no effect on revenues, but it is expected to save the firm $45,000 per year in before-tax operating costs, mainly in leasing expenses.
-The firm marginal tax rate (federal plus state) is 40%, and its MARR is 15%.

(a) Is this project acceptable, based on the most likely estimates given in the problem?

(b)If the firmÂ’s MARR is increased to 25%, what would be the required savings in leasing so that the project would remain profitable?

Our Essay Format
  • Times New Roman, 12 pt
  • 1 Inch Margins
  • Double/ Single Spacing
  • 275/ 550 Words Per Page
  • MLA/ APA/ Turabian/ Chicago style, etc

A standard double-spaced page contains 275 words

Free Features
  • Hiring a preferred expert
  • Bibliography & cover page
  • Revisions within 14-30 days
  • 24/7 customer support
payments

Team of Professional Essay Writers

With our essay service, you'll find an essay writer for any task. Their rating is based on previous customer reviews and successful orders. Before you hire a writer, you can familiarize yourself with their track record in detail.