Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Fill out the Red, and the Per BS thanks! begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} hline INPUT AREA & & & Income Statement & & & & Balance Sheets &
Fill out the Red, and the Per BS
thanks!
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline INPUT AREA & & & Income Statement & & & & Balance Sheets & & & & & & Shares & 10,000 & & \\ \hline Stock & $ & 39,000 & Sales & $71,400 & & & Begin & & & & & & Market/sh & $20 & & \\ \hline Cash & $ & 13,800 & (COGS) & $(41,000) & & & Cash & $ & 13,800 & AP & $5,400 & & \multicolumn{2}{|c|}{ All sales are credit } & & \\ \hline AR & $ & 4,200 & Gross Margin & $30,400 & & & AR & $ & 4,200 & Loans & $6,900 & & \multicolumn{4}{|c|}{ No PPE sold, no stock issued or new loans take } \\ \hline Inventory & $ & 16,800 & SG\&A & $6,400 & & & Inventory & $ & 16,800 & Total Liabilities & $12,300 & & EPS & & & \\ \hline PPE & $ & 34,900 & EBIT & $24,000 & & IS spans & Current Assets & $ & 34,800 & & & & PE & & & \\ \hline Depreciation LY & $ & 5,000 & Interest & 690 & & period & & & & Stock & $39,000 & & Div Pay & & & \\ \hline AP & $ & 5,400 & EBT & $23,310 & & between & PPE & $ & 34,900 & RE & $13,400 & & Div Yield & & & \\ \hline Loan & $ & 6,900 & Taxes & $5,900 & & Begin BS & (Acc Dep) & $ & (5,000) & & & & BV/ share & & & \\ \hline RE & $ & 13,400 & Net Income & $17,410 & & \& End BS & Net PPE & $ & 29,900 & Total Equity & $52,400 & & ROA & & & \\ \hline Sales & $ & 71,400 & & & & & & & & & & & ROE & & & \\ \hline Collected & $ & 70,200 & Dividends & $10,000 & & & Total Assets & $ & 64,700 & Total L+E & $64,700 & & TIE & & & \\ \hline Inventory sold & $ & 10,100 & SCF: & & & & & & & & & & D/E & & & \\ \hline Wages & $ & 25,900 & & & & \%d Assets & s End: & & & & & %dL&E & D/A & & & \\ \hline Admin & $ & 6,400 & & & & & Cash & $ & 35,110 & AP & $5,400 & & Work Cap & & & \\ \hline Depreciation TY & $ & 5,000 & & & & & AR & $ & 5,400 & Loans & $6,900 & & Current & & & \\ \hline Interest & & 690 & & & & & Inventory & $ & 6,700 & Total Liabilities & $12,300 & & Quick & & & \\ \hline IT Expense & $ & 5,900 & & & & & Current Assets & $ & 47,210 & & & & AR T/O & & & \\ \hline Dividends & $ & 10,000 & & & & & & & & Stock & $39,000 & & ACP & & & \\ \hline \multirow[t]{5}{*}{ Interest rate } & & 10% & & & & & PPE & $ & 34,900 & RE & $20,810 & & Inv T/O & & & \\ \hline & & & & & & & (Acc Dep) & & (10,000) & & & & ASP & & & \\ \hline & & & & & & & Net PPE & $ & 24,900 & Total Equity & $59,810 & & Profit Mar & & \multicolumn{2}{|l|}{ ROA dupont: } \\ \hline & & & & & Per BS: & & & & & & & & Asset T/O & & & \\ \hline & & & Change in cash & & & & Total Assets & $ & 72,110 & Total L+E & $72,110 & & FCF & & & \\ \hline & & & & & & & & & & & & & & & & \\ \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