Answered step by step
Verified Expert Solution
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
\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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started