Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For this assignment, I have to make a cash flow statement out of the balance sheet and income statement provided. How do I make this

image text in transcribed

For this assignment, I have to make a cash flow statement out of the balance sheet and income statement provided. How do I make this into a cash flow statement? If I were to add another sheet in the excel workbook how would I go about constructing the cash flow sheet and from there what data from the income sheet and balance sheet would I put into the cash flow statement? Thank you so much!

image text in transcribedimage text in transcribedimage text in transcribed

Unit 5 Assignment 5.2: Cash Flow Statement Due Date: The evening prior to the start of class meeting 6 by 11:59 PM EST. Total Points: 100 Overview: 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. . NNUAL BALANCE SHEET Wicked Good Cupcake ($ Thousands) 31-Dec-15 31-Dec-16 ASSETS Cash & Short-Term Investments Net Receivables Inventories Prepaid Expenses Other Current Assets $17.11 $1.62 $42.72 $0.00 $3.38 $25.05 $1.84 $39.68 $0.00 $2.93 Total Current Assets $64.84 $69.49 Gross Plant, Property & Equipment Accumulated Depreciation $63.75 $36.16 $58.28 $32.61 $27.58 Net Plant, Property & Equipment Intangibles Other Assets $5.88 $25.67 $6.01 $5.81 $6.16 TOTAL ASSETS $104.47 $106.98 LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities $0.00 $10.59 $1.87 $7.19 $1.88 $0.00 $11.91 $2.01 $6.91 $1.85 Total Current Liabilities $21.54 $22.67 Long Term Debt Deferred Taxes Other Liabilities $6.95 $1.16 $3.04 $19.79 $2.32 $2.43 TOTAL LIABILITIES $32.68 $47.21 EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock $0.07 $27.25 $73.89 $29.42 $0.06 $24.31 $61.10 $25.71 TOTAL EQUITY $71.79 $59.77 TOTAL LIABILITIES & EQUITY $104.47 $106.98 Common Shares Outstanding $5.14 $5.05 Annual Income Statement ($ Thousands, except per share ) Sales Cost of Goods Sold $179.24 $95.71 $164.28 $91.99 Gross Profit Selling, General, & Administrative Exp. $83.53 $56.36 $72.29 $50.65 Operating Income Before Deprec. Depreciation, Depletion, & Amortization $27.17 $5.85 $21.64 $5.89 Operating Profit $21.33 $15.74 Interest Expense Non-Operating Income/Expense Special Items $0.88 $0.93 $0.00 $0.56 $0.31 $0.00 Pretax Income Total Income Taxes $21.38 $7.23 $15.49 $5.60 Income Before Extraordinary Items & Discontinued Operations $14.15 $9.90 Savings Due to Common Stock Equiv. $0.00 $0.00 Adjusted Net Income $14.15 $9.90 EPS Basic from Operations EPS Diluted from Operations $0.26 $0.25 $0.19 $0.19 Dividends Per Share $0.02 $0.00 Com Shares for Basic EPS Com Shares for Diluted EPS $5.06 $5.21 $5.12 $5.27 31-Dec-15 31-Dec-16 19.71% 13.54% 16.56% 19.71% Profitability Ratios (in %) Return on equity Return on assets Return on invested capital Profit margin Gross margin 7.89% 46.60% 6.02% 44.00% Turnover-Control Ratios Asset tur nover Fixed-asset turnover Inventory turnover Collection period (days) Days' sales in cash Payables period 1.715721 1.535599 6.497942 6.398322 4.195548 4.140388 3.300403 4.078931 40.39192 47.26046 Leverage and Liquidity Ratios Assets to equity Debt to assets Debt to equity Times interest earned Current ratio Acid test 1.455284 1.789984 0.066518 0.18495 0.096802 0.331058 24.29883 28.07337 3.010679 3.010679 1.026997 1.314694 Unit 5 Assignment 5.2: Cash Flow Statement Due Date: The evening prior to the start of class meeting 6 by 11:59 PM EST. Total Points: 100 Overview: 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. . NNUAL BALANCE SHEET Wicked Good Cupcake ($ Thousands) 31-Dec-15 31-Dec-16 ASSETS Cash & Short-Term Investments Net Receivables Inventories Prepaid Expenses Other Current Assets $17.11 $1.62 $42.72 $0.00 $3.38 $25.05 $1.84 $39.68 $0.00 $2.93 Total Current Assets $64.84 $69.49 Gross Plant, Property & Equipment Accumulated Depreciation $63.75 $36.16 $58.28 $32.61 $27.58 Net Plant, Property & Equipment Intangibles Other Assets $5.88 $25.67 $6.01 $5.81 $6.16 TOTAL ASSETS $104.47 $106.98 LIABILITIES Long Term Debt Due In One Year Accounts Payable Taxes Payable Accrued Expenses Other Current Liabilities $0.00 $10.59 $1.87 $7.19 $1.88 $0.00 $11.91 $2.01 $6.91 $1.85 Total Current Liabilities $21.54 $22.67 Long Term Debt Deferred Taxes Other Liabilities $6.95 $1.16 $3.04 $19.79 $2.32 $2.43 TOTAL LIABILITIES $32.68 $47.21 EQUITY Common Stock Capital Surplus Retained Earnings Less: Treasury Stock $0.07 $27.25 $73.89 $29.42 $0.06 $24.31 $61.10 $25.71 TOTAL EQUITY $71.79 $59.77 TOTAL LIABILITIES & EQUITY $104.47 $106.98 Common Shares Outstanding $5.14 $5.05 Annual Income Statement ($ Thousands, except per share ) Sales Cost of Goods Sold $179.24 $95.71 $164.28 $91.99 Gross Profit Selling, General, & Administrative Exp. $83.53 $56.36 $72.29 $50.65 Operating Income Before Deprec. Depreciation, Depletion, & Amortization $27.17 $5.85 $21.64 $5.89 Operating Profit $21.33 $15.74 Interest Expense Non-Operating Income/Expense Special Items $0.88 $0.93 $0.00 $0.56 $0.31 $0.00 Pretax Income Total Income Taxes $21.38 $7.23 $15.49 $5.60 Income Before Extraordinary Items & Discontinued Operations $14.15 $9.90 Savings Due to Common Stock Equiv. $0.00 $0.00 Adjusted Net Income $14.15 $9.90 EPS Basic from Operations EPS Diluted from Operations $0.26 $0.25 $0.19 $0.19 Dividends Per Share $0.02 $0.00 Com Shares for Basic EPS Com Shares for Diluted EPS $5.06 $5.21 $5.12 $5.27 31-Dec-15 31-Dec-16 19.71% 13.54% 16.56% 19.71% Profitability Ratios (in %) Return on equity Return on assets Return on invested capital Profit margin Gross margin 7.89% 46.60% 6.02% 44.00% Turnover-Control Ratios Asset tur nover Fixed-asset turnover Inventory turnover Collection period (days) Days' sales in cash Payables period 1.715721 1.535599 6.497942 6.398322 4.195548 4.140388 3.300403 4.078931 40.39192 47.26046 Leverage and Liquidity Ratios Assets to equity Debt to assets Debt to equity Times interest earned Current ratio Acid test 1.455284 1.789984 0.066518 0.18495 0.096802 0.331058 24.29883 28.07337 3.010679 3.010679 1.026997 1.314694

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

Cost Accounting A Managerial Emphasis

Authors: Charles T Horngren

5th Edition

0131796712, 978-0131796713

More Books

Students also viewed these Accounting questions

Question

2.3 Define human resource ethics.

Answered: 1 week ago

Question

9 How can training be evaluated?

Answered: 1 week ago