Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. begin{tabular}{|l|l|l|l|l|l|l|} hline Year & (

image text in transcribed For the following organisation, calculate the undiscounted cash flow. You can do it in Excel and paste the result below. \\begin{tabular}{|l|l|l|l|l|l|l|} \\hline Year & \\( \\mathbf{0} \\) & \\( \\mathbf{1} \\) & \\( \\mathbf{2} \\) & \\( \\mathbf{3} \\) & \\( \\mathbf{4} \\) & \\( \\mathbf{5} \\) \\\\ \\hline Unit Price & - & \\( \\$ 105 \\) & \\( \\$ 110 \\) & \\( \\$ 115 \\) & \\( \\$ 120 \\) & \\( \\$ 125 \\) \\\\ \\hline Units Sold & - & 900 & 1000 & 1100 & 1200 & 1300 \\\\ \\hline Net Sales & - & & & & & \\\\ \\hline Variable Costs & - & \\( \\$ 54,000 \\) & \\( \\$ 60,000 \\) & \\( \\$ 66,000 \\) & \\( \\$ 72,000 \\) & \\( \\$ 78,000 \\) \\\\ \\hline Fixed Costs & - & \\( \\$ 15,000 \\) & \\( \\$ 15,750 \\) & \\( \\$ 16,538 \\) & \\( \\$ 17,364 \\) & \\( \\$ 18,233 \\) \\\\ \\hline Depreciation & - & \\( \\$ 13,000 \\) & \\( \\$ 13,000 \\) & \\( \\$ 13,000 \\) & \\( \\$ 13,000 \\) & \\( \\$ 13,000 \\) \\\\ \\hline PBIT & - & \\( \\$ 25,500 \\) & \\( \\$ 34,250 \\) & \\( \\$ 43,962 \\). & & \\\\ \\hline Tax@40\\% & - & & & & & \\\\ \\hline NOPAT & - & & & & & \\\\ \\hline Adjustments & - & & & & & \\\\ \\hline \\( \\begin{array}{l}\\text { Add back } \\\\ \\text { Depreciation }\\end{array} \\) & & & & & & \\\\ \\hline \\( \\begin{array}{l}\\text { CapEx }\\end{array} \\) & & & & & & \\\\ \\hline Salvage value & - & - & - & - & - & \\( \\$ 40,000 \\) \\\\ \\hline Net cash flow & & & & & & \\\\ \\hline \\( \\begin{array}{l}\\text { Cumulative cash } \\\\ \\text { flow }\\end{array} \\) & & & & & & \\\\ \\hline \\end{tabular} Place your answer (Excel) in the space below. Alternatively, do the exercise in Excel and enter the values back into the table above

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

Personal Finance

Authors: Thomas Garman, Raymond Forgue

12th edition

9781305176409, 1133595839, 1305176405, 978-1133595830

More Books

Students also viewed these Finance questions