Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Revenues are projected to be $500,000 the first year and is expected to increase by 20% the second year, 15% the third year and to

Revenues are projected to be $500,000 the first year and is expected to increase by 20% the second year, 15% the third year and to continue to increase at 10% thereafter. Fixed annual operating costs are expected to be salaries of $110,000, Utilities $75,000, Food and Liquor License is 15% of gross revenues and taxes are 40% of net revenues. Calculate the depreciation and Operating cash flow from what I have here

image text in transcribed \begin{tabular}{|c|c|c|c|c|c|} \hline & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 \\ \hline Revenue & 500,000.00 & 600,000.00 & 690,000.00 & 759,000.00 & 834,900.00 \\ \hline \multicolumn{6}{|l|}{\begin{tabular}{l} Fixed \\ Operating \\ Costs \end{tabular}} \\ \hline Salaries & 110,000.00 & 110,000.00 & 110,000.00 & 110,000.00 & 110,000.00 \\ \hline Utilities & 75,000.00 & 75,000.00 & 75,000.00 & 75,000.00 & 75,000.00 \\ \hline \begin{tabular}{l} Food \& \\ Liquor \\ License \end{tabular} & $75,000.00 & 90,000.00 & 103,500.00 & 113,850.00 & 125,235.00 \\ \hline Marketing & 100,000.00 & & & & \\ \hline \multicolumn{6}{|c|}{ Depreciation } \\ \hline \begin{tabular}{l} Earnings \\ before tax \end{tabular} & 140,000.00 & 325,000.00 & 401,500.00 & 460,150.00 & 524,665.00 \\ \hline Taxes & 56,000.00 & 130,000.00 & 160,600.00 & 184,060.00 & 209,866.00 \\ \hline \multicolumn{6}{|c|}{ Depreciation } \\ \hline \begin{tabular}{l} Operating \\ cash flow \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

Financial Institutions And Markets

Authors: Jeff Madura

10th International Edition

0538482176, 9780538482172

More Books

Students also viewed these Finance questions

Question

How does one identify the essential functions of a job?

Answered: 1 week ago

Question

5. What are the other economic side effects of accidents?

Answered: 1 week ago