Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you help with npv, IRR, MIRR,and Payback need help wants to purchase a new truck for $220,000 and has a old truck for $70,000

can you help with npv, IRR, MIRR,and Payback
need help
image text in transcribed
wants to purchase a new truck for $220,000 and has a old truck for $70,000
cash out flows and inflows we belive are calculated correctly?
we need help with NPV and IRR, MIRR and WAAC
image text in transcribed
image text in transcribed
image text in transcribed
please help with the capital budgeting image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
= \begin{tabular}{c|l|r|} \hline 9 & & \\ 10 & Input Data: \\ 11 & Truck Cost \\ 12 & Insurance Cost & 220000 \\ 13 & Registration Cost & 10000 \\ 14 & Change in net Working Capital & \\ 15 & Total Cost & 230000 \\ \hline \end{tabular} output Data: 164000 \begin{tabular}{|l|l|l|l|l|l|} \hline Cash inflows & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ & $19,200.00 & $63,900.00 & $55,567.00 & $62,608.00 & $87,452.00 \\ \hline \end{tabular} Sensitivity Analysis: Possible Variables: Fuel cost, revenue, Salvage Value Analysis 1 Variable Change Fuel price 30%20%10% Base Level Analysis 2 Breakeven Analysis = \begin{tabular}{c|l|r|} \hline 9 & & \\ 10 & Input Data: \\ 11 & Truck Cost \\ 12 & Insurance Cost & 220000 \\ 13 & Registration Cost & 10000 \\ 14 & Change in net Working Capital & \\ 15 & Total Cost & 230000 \\ \hline \end{tabular} output Data: 164000 \begin{tabular}{|l|l|l|l|l|l|} \hline Cash inflows & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ & $19,200.00 & $63,900.00 & $55,567.00 & $62,608.00 & $87,452.00 \\ \hline \end{tabular} Sensitivity Analysis: Possible Variables: Fuel cost, revenue, Salvage Value Analysis 1 Variable Change Fuel price 30%20%10% Base Level Analysis 2 Breakeven Analysis

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Continuous Auditing Theory And Application

Authors: David Y. Chan, Victoria Chiu

1st Edition

1787434141, 978-1787434141

More Books

Students also viewed these Accounting questions