FINANCIAL STATEMENT EXCEL TEMPLATE Operating Cash Flow for 2016- Operating Cash Flow for 2017 = GIVEN...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
FINANCIAL STATEMENT EXCEL TEMPLATE Operating Cash Flow for 2016- Operating Cash Flow for 2017 = GIVEN DATA: Income statement 2016 2017 2016 2017 Cost of Goods Sold Cash 201,943 252,768 30,629 32,567 Depreciation 56,876 64,826 Interest expense 13,130 14,925 Selling & Administrative Expenses 43,130 53,753 Accounts Payable 52,910 58,998 Net Fixed Assets 262,617 314,625 Sales 403,456 485,832 Accounts Receivable 21,524 27,652 Notes Payable 24,308 26,915 Long-term Debt 129,342 144,570 Inventory 45,785 58,425 Tax Rate 35% 35% Dividend Payout % 50% 50% Balance Sheet 2016 ▾ Part 1: Preparing a Balance Sheet ⚫ Using the Financial Statement Excel Template, which includes the needed data, prepare a balance sheet for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, how would you interpret the quality of the balance sheet? In your response, be sure to address whether there is excessive leverage, enough cash to make payroll and/or buy equipment, et cetera. (75-150 words, or 1-2 paragraphs) ⚫ Based on your interpretation of the balance sheet, would you recommend lending to the company? Explain why or why not, including any potential risks. (75-150 words, or 1-2 paragraphs) Part 2: Building an Income Statement ⚫ Using the Financial Statement Excel Template, which includes the needed data, prepare an income statement for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, address the following using Medi-Supply's income statement: ⚫ Interpret the quality of the income statement for this company. Is the income statement improving or deteriorating over time? Explain your answer, including why you reached your conclusion. (75-150 words, or 1-2 paragraphs) ° ⚫ Describe whether or not this company is profitable. If the company is unprofitable, explain if it is growing fast enough for sales to outpace expenses. (75 words, or 1 paragraph) ⚫ Based on their income statement, would you invest in the company? (75 words, or 1 paragraph) Part 3: Calculating the Operating Cash Flow ⚫ Using the Financial Statement Excel Template, which includes the needed data, compute the operating cash flow for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, address the following using Medi-Supply's operating cash flow: ⚫ Interpret the quality of the operating cash flow for this company. Is the operating cash flow improving or deteriorating over time? Explain your answer, as well as why you reached your conclusion. (75-150 words, or 1-2 paragraphs) ⚫ Describe whether or not the company generates positive cash flow from operations. (75 words, or 1 paragraph) ⚫ Based on the quality of their cash flow, would you invest in the company? (75 words, or 1 paragraph) FINANCIAL STATEMENT EXCEL TEMPLATE Operating Cash Flow for 2016- Operating Cash Flow for 2017 = GIVEN DATA: Income statement 2016 2017 2016 2017 Cost of Goods Sold Cash 201,943 252,768 30,629 32,567 Depreciation 56,876 64,826 Interest expense 13,130 14,925 Selling & Administrative Expenses 43,130 53,753 Accounts Payable 52,910 58,998 Net Fixed Assets 262,617 314,625 Sales 403,456 485,832 Accounts Receivable 21,524 27,652 Notes Payable 24,308 26,915 Long-term Debt 129,342 144,570 Inventory 45,785 58,425 Tax Rate 35% 35% Dividend Payout % 50% 50% Balance Sheet 2016 ▾ Part 1: Preparing a Balance Sheet ⚫ Using the Financial Statement Excel Template, which includes the needed data, prepare a balance sheet for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, how would you interpret the quality of the balance sheet? In your response, be sure to address whether there is excessive leverage, enough cash to make payroll and/or buy equipment, et cetera. (75-150 words, or 1-2 paragraphs) ⚫ Based on your interpretation of the balance sheet, would you recommend lending to the company? Explain why or why not, including any potential risks. (75-150 words, or 1-2 paragraphs) Part 2: Building an Income Statement ⚫ Using the Financial Statement Excel Template, which includes the needed data, prepare an income statement for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, address the following using Medi-Supply's income statement: ⚫ Interpret the quality of the income statement for this company. Is the income statement improving or deteriorating over time? Explain your answer, including why you reached your conclusion. (75-150 words, or 1-2 paragraphs) ° ⚫ Describe whether or not this company is profitable. If the company is unprofitable, explain if it is growing fast enough for sales to outpace expenses. (75 words, or 1 paragraph) ⚫ Based on their income statement, would you invest in the company? (75 words, or 1 paragraph) Part 3: Calculating the Operating Cash Flow ⚫ Using the Financial Statement Excel Template, which includes the needed data, compute the operating cash flow for Medi-Supply. Be sure to use proper Excel formulas to show your work in cells where math is involved to derive the answers. ⚫ Using the Business Report Template, address the following using Medi-Supply's operating cash flow: ⚫ Interpret the quality of the operating cash flow for this company. Is the operating cash flow improving or deteriorating over time? Explain your answer, as well as why you reached your conclusion. (75-150 words, or 1-2 paragraphs) ⚫ Describe whether or not the company generates positive cash flow from operations. (75 words, or 1 paragraph) ⚫ Based on the quality of their cash flow, would you invest in the company? (75 words, or 1 paragraph)
Expert Answer:
Answer rating: 100% (QA)
ANSWER Part 1 Preparing a Balance Sheet 2016 2017 Assets Cash 30629 32567 Accounts Receivable 21524 27652 Inventory 45785 58425 Net Fixed Assets 26261... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation
ISBN: 978-0324302950
6th edition
Authors: Clyde P. Stickney
Posted Date:
Students also viewed these accounting questions
-
Use the attached "words.txt" file to store the words along with their ranks in an AVL tree. Then provide the user the option to search for any word. If the word exists the program displays the rank...
-
A 40-cm-long, 800-W electric resistance heating element with diameter 0.5 cm and surface temperature 120C is immersed in 75 kg of water initially at 20C. Determine how long it will take for this...
-
Engine Pro reconditions engines. Its job costing records yield the following information. Engine Pro uses a perpetual inventory system. Requirements 1. Compute Engine Pro's cost of (a) Work in...
-
Why is the target market placed in the center of the four Ps in the text diagram of a marketing strategy (Exhibit 2-4)? Explain, using a specific example from your own experience. In Exhibit 2-4 Ducr...
-
What are some of the disadvantages of using social media?
-
Following is a list of cost system characteristics and sample companies. Match each to either job order costing or process costing. a. Companies that produce small quantities of many different...
-
Given the importance of network security, describe the key features that a network security policy should include, as well as procedures that should be included. a)Given the importance of network...
-
During the courtship and negotiation stages, managers often emphasize "equal partnerships" and do not reveal (or even try to hide) their true intentions. What are the ethical dilemmas here?
-
RECEPTIONIST DEALERSHIP Briefly describe the task(s) The receptionist at a car dealership Working at a car dealership has shown me several benefits, including: Sales experience, I have gained...
-
The slope of a supply curve is most often: A. zero. B. positive. C. negative.
-
What role does the opportunity cost rate play in calculating financial returns?
-
Consider these two quotes concerning recent Federal Reserve policy On December 12, 2012 the Federal Reserve issued the following statement: "In particular, the Committee decided to keep the target...
-
Is the calculation of financial return an application of time value analysis? Explain your answer.
-
Two-dimensional demand and supply curves are drawn under which of the following assumptions? A. Own price is held constant. B. All variables but quantity are held constant. C. All variables but own...
-
7.2 The lens with a focal lengths of +80.0 cm and mirror with a focal lengths of -50.0 cm are separated by 1.00 m as shown in Figure 6. If an object is placed 1.00 m to the left of the lens, (a)...
-
Find the velocity, acceleration, and speed of a particle with the given position function. r(t) = (t 2 , sin t - t cos t, cos t + t sin t), t > 0
-
Intel is a global leader in manufacturing semiconductors. Computer chip manufacturing is very capital intensive. In addition, the production processes in computer chip manufacturing require very...
-
Ruby Tuesday, Inc. owns and operates Ruby Tuesday casual dining restaurants. The firm also franchises the Ruby Tuesday concept in selected domestic and international markets. As of the end of Year...
-
"With respect to asset valuation, reliability and relevance are often on opposite ends of the continuum." Explain.
-
Using an economic balance sheet, which of the Laws current financial assets is most concerning from an asset allocation perspective? A. Equities B. Real estate C. Fixed income Raye uses a costbenefit...
-
Using the economic balance sheet approach, the Laws economic net worth is closest to: A. $925,000. B. $1,425,000. C. $1,675,000. Raye uses a costbenefit approach to rebalancing and recommends that...
-
Raye believes the previous advisers asset class specifications for equity and derivatives are inappropriate given that, for purposes of asset allocation, asset classes should be: A. diversifying. B....
Study smarter with the SolutionInn App