Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Could you please give step by step procedures explaining how we got these values ? Need answer in next 12 hours. Thanks begin{tabular}{|c|c|c|c|c|c|c|} hline &
Could you please give step by step procedures explaining how we got these values ? Need answer in next 12 hours. Thanks
\begin{tabular}{|c|c|c|c|c|c|c|} \hline & 0 & 1 & 2 & 3 & 4 & 5 \\ \hline \begin{tabular}{l} Revenue \\ Cash Expense \end{tabular} & & \begin{tabular}{r} $100,0000.00 \\ $50,000.00 \end{tabular} & \begin{tabular}{r} $120,0000.00 \\ $60,0000.00 \end{tabular} & \begin{tabular}{r} $140,0000.00 \\ $70,000.00 \end{tabular} & \begin{tabular}{l} $150,0000.00 \\ $7,5000.00 \end{tabular} & \begin{tabular}{|l} $150,0000.00 \\ $75,0000.00 \end{tabular} \\ \hline Book Depreciation & & $20,000.00 & $20,000.00 & $20,000.00 & $20,000.00 & $20,000.00 \\ \hline Book Income Pre-Tax & & $30,000.00 & $40,000.00 & $50,000,00 & $55,00000 & $5500000 \\ \hline Book Tax at 32% & & $10,000.00 & $13,000.00 & $16,000.00 & $18,000.00 & $ \\ \hline After Tax Book Income & & $20,000.00 & $27,000.00 & $34,000.00 & $37,000.00 & $37,000.00 \\ \hline Financial Measures & & & & & & \\ \hline Profit Margin \% & & 20.00% & 22.50% & 24.29% & 24.67% & 24.67% \\ \hline Net Assets & $100,000.00 & $80,000.00 & & $40,000.00 & $20,000.00 & \$- \\ \hline ROA \% & 0.00% & 25.00% & \begin{tabular}{l} 300,00.00% \\ 45.00% \\ \end{tabular} & 85.00% & 185.00% & N/M \\ \hline Cashflow & & & & & & \\ \hline Revenue & & $100,000.00 & $120,000.00 & $140,000.00 & $150,000.00 & $150,000.00 \\ \hline Cash Expense & & $50,000.00 & $60,000.00 & $70,000.00 & $75,000.00 & $75,000.00 \\ \hline \begin{tabular}{l} Tax Depreciation \\ Pretax Income \end{tabular} & & $20,000.00 & $32,000.00 & $19,000.00 & $12,000.00 & $17,000.00 \\ \hline \begin{tabular}{c} Pretax Income \\ Tax an 32% \end{tabular} & & \begin{tabular}{l} $30,000.00 \\ $10,0000 \end{tabular} & $$9,000.00$28,000.00 & \begin{tabular}{l} $51,0,000.00 \\ $16,000.00 \end{tabular} & \begin{tabular}{l} $63,000.00 \\ 20,000.00 \end{tabular} & \\ \hline After Tax Income & & $20,000.00 & $19,000.00 & $35,000.00 & $43,000.00 & $39,000.00 \\ \hline & $(100,000,00 & $40,00000 & $51.00000 & $5400000 & & $56,000.00 \\ \hline \begin{tabular}{l} Ater lax Casstiow \\ Cumulative Cashlow \end{tabular} & $ & \begin{tabular}{l} $44,000.000 \\ (60,000.00) \\ \end{tabular} & & \begin{tabular}{l} $54,400.000 \\ $45,000.00 \end{tabular} & \begin{tabular}{l} $55,000.00 \\ $100,000.00 \end{tabular} & \begin{tabular}{|l} $35,0,000.00 \\ 156,000.00 \\ \end{tabular} \\ \hline Payback Period & & & & & & \\ \hline Present Worth 10 & $91,000 & & & & & \\ \hline \begin{tabular}{l} PW12 \\ PW15 \end{tabular} & $82,000 & & & & & \\ \hline IRR & 39.4% & & & & & \\ \hlinePVlndex(15) & 0.68 & & & & & \\ \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