Question
In this assignment, you will be creating a cash flow statement based on the Wicked Good Cupcakes income statement and balance sheet. Instructions: Using the
In this assignment, you will be creating a cash flow statement based on the Wicked Good Cupcakes income statement and balance sheet.
Instructions:
Using the Income Statement and Balance Sheet provided in Unit 2, generate a Cash Flow Statement. You may have to make some assumptions in the process; list them in a comment column of your Cash Flow Statement.
Summarize your findings and observations.
What is your analysis of their current profit vs. cash situation?
Are they in danger of running out of cash? What are your findings? Explain.
What does their, as Warren Buffet, refers, owning earnings (free cash flow) look like?
Requirements: Two to three-pages, excluding the Title and Reference pages. All questions posed must be addressed completely. APA format, including in-text citations for referenced works.
Cash Flow Statement \begin{tabular}{l|l} Balance Sheet Income Statement & Int \end{tabular} Ready BUS523 Unit 3 WGC Cash Flow Template Home Insert Draw Page Layout Formulas Data Review View @ Tell me Paste Calibri (Body) B I Uv 11AA Conditional Formatting as Table CollStyles Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B1 \begin{tabular}{l} \hline \\ \hline 1 \end{tabular} Annual Income Statement (\$ Thousands, except per share ) Sales Cost of Goods Sold Gross Profit Selling, General, \& Administrative Exp. Operating Income Before Deprec. Depreciation,Depletion,\&Amortization Operating Profit Interest Expense Non-Operating Income/Expense Special Items Pretax Income Total Income Taxes Income Before Extraordinary Items \& Discontinued Operations Savings Due to Common Stock Equiv. Adjusted Net Income EPS Basic from Operations EPS Diluted from Operations Dividends Per Share Com Shares for Basic EPS Com Shares for Diluted EPS \begin{tabular}{|r|r|} 2015 & 2016 \\ \hline$179.24 & $164.28 \\ \hline \end{tabular} \begin{tabular}{r|r} $95.71 & $91.99 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$83.53 & $72.29 \\ \hline$56.36 & $50.65 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $27.17 & $21.64 \\ \hline$5.85 & $5.89 \\ \hline \end{tabular} $21.33$15.74 $0.88$0.56 $0.93 $0.31 \begin{tabular}{|r|r|} \hline$21.38 & $15.49 \\ \hline$7.23 & $5.60 \\ \hline \end{tabular} $14.15$9.90 $0.00 $0.00 $14.15 $9.90 \begin{tabular}{|r|r|} \hline$0.26 & $0.19 \\ \hline$0.25 & $0.19 \\ \hline \end{tabular} $0.02$0.00 \begin{tabular}{|l|r|} \hline$5.06 & $5.12 \\ \hline$5.21 & $5.27 \\ \hline \end{tabular} 41 Cash Flow Statement Balance Sheet Income Statement Ready BUS523 Unit 3 WGC Cash Flow Template Home Insert Draw Page Layout Formulas Data Review View @ Tell me Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D5 D \begin{tabular}{|l|l|l|} \hline E & F & G \\ \hline \end{tabular} H \begin{tabular}{|l|l|l|l|l|} \hline I & J & K & L & M \\ \hline \end{tabular} \begin{tabular}{l|l} \hline N & o \\ \hline \end{tabular} (\$ Thousands) ASSETS Cash \& Short-Term Investments Net Receivables Prepaid Expenses Other Current Assets Total Current Assets Gross Plant, Property \& Equipment Accumulated Depreciation Net Plant, Property \& Equipment Intangibles Other Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Other Liabilities TOTAL LIABILITIES EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock TOTAL EQUITY TOTAL LIABILITIES \& EQUITY Common Shares Outstanding \begin{tabular}{|l|r|} $17.11 & $25.05 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $1.62 & $1.84 \\ \hline$42.72 & $39.68 \\ \hline$0.00 & $0.00 \end{tabular} \begin{tabular}{|l|r|} \hline$0.00 & $0.00 \\ \hline$3.38 & $2.93 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$64.84 & $69.49 \\ \hline \end{tabular} \begin{tabular}{|l|r|} $63.75 & $58.28 \\ \hline$36.16 & $32.61 \end{tabular} \begin{tabular}{|l|r|} $36.16 & $32.61 \\ \hline$27.58 & $25.67 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline$27.58 & $25.67 \\ \hline$5.88 & $6.01 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $6.16 & $5.81 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $104.47 & $106.98 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $0.00 & $0.00 \\ \hline$10.59 & $11.91 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline$10.59 & $11.91 \\ \hline$1.87 & $2.01 \\ \hline$7.19 & $6.91 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$1.19 & $6.91 \\ \hline$1.88 & $1.85 \\ \hline \end{tabular} $21.54$22.67 \begin{tabular}{|r|r|} \hline$6.95 & $19.79 \\ \hline$1.16 & $2.32 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$1.16 & $2.32 \\ \hline$3.04 & $2.43 \\ \hline \end{tabular} \begin{tabular}{|l|r|} $32.68 & $47.21 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $0.07 & $0.06 \\ \hline$27.25 & $24.31 \end{tabular} \begin{tabular}{|l|r|} $27.25 & $24.31 \\ \hline$73.89 & $61.10 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$73.89 & $61.10 \\ \hline$29.42 & $25.71 \\ \hline \end{tabular} \begin{tabular}{|} $71.79$59.77 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $104.47 & $106.98 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $5.14 & $5.05 \\ \hline \end{tabular} Balance Sheet Income Statement Ready Cash Flow Statement Balance Sheet Statement + Cash Flow Statement \begin{tabular}{l|l} Balance Sheet Income Statement & Int \end{tabular} Ready BUS523 Unit 3 WGC Cash Flow Template Home Insert Draw Page Layout Formulas Data Review View @ Tell me Paste Calibri (Body) B I Uv 11AA Conditional Formatting as Table CollStyles Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B1 \begin{tabular}{l} \hline \\ \hline 1 \end{tabular} Annual Income Statement (\$ Thousands, except per share ) Sales Cost of Goods Sold Gross Profit Selling, General, \& Administrative Exp. Operating Income Before Deprec. Depreciation,Depletion,\&Amortization Operating Profit Interest Expense Non-Operating Income/Expense Special Items Pretax Income Total Income Taxes Income Before Extraordinary Items \& Discontinued Operations Savings Due to Common Stock Equiv. Adjusted Net Income EPS Basic from Operations EPS Diluted from Operations Dividends Per Share Com Shares for Basic EPS Com Shares for Diluted EPS \begin{tabular}{|r|r|} 2015 & 2016 \\ \hline$179.24 & $164.28 \\ \hline \end{tabular} \begin{tabular}{r|r} $95.71 & $91.99 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$83.53 & $72.29 \\ \hline$56.36 & $50.65 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $27.17 & $21.64 \\ \hline$5.85 & $5.89 \\ \hline \end{tabular} $21.33$15.74 $0.88$0.56 $0.93 $0.31 \begin{tabular}{|r|r|} \hline$21.38 & $15.49 \\ \hline$7.23 & $5.60 \\ \hline \end{tabular} $14.15$9.90 $0.00 $0.00 $14.15 $9.90 \begin{tabular}{|r|r|} \hline$0.26 & $0.19 \\ \hline$0.25 & $0.19 \\ \hline \end{tabular} $0.02$0.00 \begin{tabular}{|l|r|} \hline$5.06 & $5.12 \\ \hline$5.21 & $5.27 \\ \hline \end{tabular} 41 Cash Flow Statement Balance Sheet Income Statement Ready BUS523 Unit 3 WGC Cash Flow Template Home Insert Draw Page Layout Formulas Data Review View @ Tell me Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates D5 D \begin{tabular}{|l|l|l|} \hline E & F & G \\ \hline \end{tabular} H \begin{tabular}{|l|l|l|l|l|} \hline I & J & K & L & M \\ \hline \end{tabular} \begin{tabular}{l|l} \hline N & o \\ \hline \end{tabular} (\$ Thousands) ASSETS Cash \& Short-Term Investments Net Receivables Prepaid Expenses Other Current Assets Total Current Assets Gross Plant, Property \& Equipment Accumulated Depreciation Net Plant, Property \& Equipment Intangibles Other Assets TOTAL ASSETS LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Other Current Liabilities Total Current Liabilities Long Term Debt Deferred Taxes Other Liabilities TOTAL LIABILITIES EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock TOTAL EQUITY TOTAL LIABILITIES \& EQUITY Common Shares Outstanding \begin{tabular}{|l|r|} $17.11 & $25.05 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $1.62 & $1.84 \\ \hline$42.72 & $39.68 \\ \hline$0.00 & $0.00 \end{tabular} \begin{tabular}{|l|r|} \hline$0.00 & $0.00 \\ \hline$3.38 & $2.93 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$64.84 & $69.49 \\ \hline \end{tabular} \begin{tabular}{|l|r|} $63.75 & $58.28 \\ \hline$36.16 & $32.61 \end{tabular} \begin{tabular}{|l|r|} $36.16 & $32.61 \\ \hline$27.58 & $25.67 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline$27.58 & $25.67 \\ \hline$5.88 & $6.01 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $6.16 & $5.81 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $104.47 & $106.98 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $0.00 & $0.00 \\ \hline$10.59 & $11.91 \\ \hline \end{tabular} \begin{tabular}{|r|r|} \hline$10.59 & $11.91 \\ \hline$1.87 & $2.01 \\ \hline$7.19 & $6.91 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$1.19 & $6.91 \\ \hline$1.88 & $1.85 \\ \hline \end{tabular} $21.54$22.67 \begin{tabular}{|r|r|} \hline$6.95 & $19.79 \\ \hline$1.16 & $2.32 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$1.16 & $2.32 \\ \hline$3.04 & $2.43 \\ \hline \end{tabular} \begin{tabular}{|l|r|} $32.68 & $47.21 \\ \hline \end{tabular} \begin{tabular}{|r|r|} $0.07 & $0.06 \\ \hline$27.25 & $24.31 \end{tabular} \begin{tabular}{|l|r|} $27.25 & $24.31 \\ \hline$73.89 & $61.10 \\ \hline \end{tabular} \begin{tabular}{|l|r|} \hline$73.89 & $61.10 \\ \hline$29.42 & $25.71 \\ \hline \end{tabular} \begin{tabular}{|} $71.79$59.77 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $104.47 & $106.98 \\ \hline \end{tabular} \begin{tabular}{|l|l|} $5.14 & $5.05 \\ \hline \end{tabular} Balance Sheet Income Statement Ready Cash Flow Statement Balance Sheet Statement +
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