Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please create a cash flow diagram using excel and show all work for both Proposals! please and thank you i greatly appreciate it! Prop A

Please create a cash flow diagram using excel and show all work for both Proposals! please and thank you i greatly appreciate it! image text in transcribed
Prop A Prop B \begin{tabular}{|c|c|c|c|c|c|} \hline MV(0) & 250,00 & $ & FC(0) & 1,000,00 & $ \\ \hlineFC(5) & 650000 & $ & FC(1) & 800,000 & $ \\ \hline Salvage & 50000 & $ & FC(2) & 200,000 & $ \\ \hlineAOC & 30000 & $/yr. & AOC & 8000 & $/yr. \\ \hline N & 10 & yr. & N & 25 & yr. \\ \hline Weed & 90000 & $/yr. & AOC Inc & 1% & \\ \hline Savings & 35000 & $/yr. & Savings & 35000 & $/yr. \\ \hline AOC Inc & 4.0% & & Savings Inc & 1.0% & \\ \hline Savings Inc & 1.0% & & Repair & 30000 & \$@ 5yrs \\ \hline & & & \begin{tabular}{l} Disposal \\ Cost \end{tabular} & 300000 & \begin{tabular}{l} \$@ EOY \\ 25 \end{tabular} \\ \hline \end{tabular}

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

More Books

Students also viewed these Accounting questions