Use the Income Statement and Balance Sheet below along with forecast assumptions to build a forecast...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the Income Statement and Balance Sheet below along with forecast assumptions to build a forecast of the 2019 financial statements and the External Funding Required. SHOW YOUR WORK Net Sales Cost of goods sold Gross profit Expenses General, selling, and administrative expenses Net interest expense Earnings before tax Tax Earnings after tax Dividends Assets Current assets Cash and securities Accounts receivable Inventory Prepaid expenses Total current assets Net fixed assets Total assets Income Statement Long-term debt Common stock Retained earnings Total liabilities and owners' equity Balance Sheet Liabilities and Owners' Equity Current liabilities Bank loan Accounts payable Current Maturity Long-Term Debt Accrued wages Total current liabilities 2018 5,000 4,000 1,000 750 126 124 43 80 16 2018 685 890 500 12 2,087 250 2,337 753 570 10 4 1,337 500 100 400 2,337 0 Iterations 2019F 2019F 2019 Assumptions 8 percent growth 75 percent of sales 20 percent of sales 10 percent interest 25 percent tax 25 percent dividend payout 60 days sales 72 day collection period 7 times turnover hold at 2018 level 10 depreciation per year plug, initially zero 60 days payable estimate hold at 2018 level 10 amortization per year hold at 2018 level previous RE+NI-divs Answer Formula Sheet Debt/Capitalization = Total debt/(Total equity + total debt) Payables deferral period= payables/cost of goods sold per day Inventory conversion period inventory/cost of goods sold per day Cash conversion cycle = inventory conversion period + days sales outstanding-pavables deferral period Current ratio Current assets/current liabilities Acid test, quick ratio = (current assets-inventory)/ current liabilities Days cash sales cash/(sales/365) Working capital current assets-current liabilities Debt-to-asset ratio (debt ratio) = Total debt/total assets Days sales outstanding account receivables/(sales/365) Gross profit margin = (sales-cost of goods sold)/sales Inventory turnover = Cost of goods sold/ending inventory Total liabilities = assets x (liabilities/assets) Shareholders' equity = total assets-total liabilities Payables period = accounts payable/(cost of goods sold/365) ROE = Net income / equity Gross profit= sales-cost of goods sold Three-factor DuPont = Net profit margin x asset turnover x financial leverage Profit margin = Net income/sales Cash conversion cycle = collection period + inventory processing period - payables period I Inventory processing period = 365/inventory turnover Retained earnings, retained earnings, + net income,-dividends, Financial leverage [equity multiplier] = assets/equity Total asset turnover = sales/assets Dividend payout=1-retention rate Retention rate = 1-dividend payout ROA= Net income / total assets ROICEBIT(1-tax rate)/(interest-bearing debt + equity) g=change in sales growth [(growth new/growth old)-1] Debt/Capitalization = Total debt/(Total equity + total debt) EBIT interest coverage [times interest earned] EBIT/interest expense EBITDA interest coverage = EBITDA/interest expense E=mc² Area = 1/3 xr²h NOPAT = EBIT(1-tax rate); Free cash flow = NOPAT-ANet PPE +/- ANet Operating Working Capital Net operating working capital = (Cash + A/R + Inventory)-(A/P + Accruals) Cost of carrying receivables = (DSO)x Average sales per day x (Variable cost ratio) x (Cost of funds) AP = change in gross profit-change in cost of carrying receivables - change in bad debt losses-change in cost of discounts Use the Income Statement and Balance Sheet below along with forecast assumptions to build a forecast of the 2019 financial statements and the External Funding Required. SHOW YOUR WORK Net Sales Cost of goods sold Gross profit Expenses General, selling, and administrative expenses Net interest expense Earnings before tax Tax Earnings after tax Dividends Assets Current assets Cash and securities Accounts receivable Inventory Prepaid expenses Total current assets Net fixed assets Total assets Income Statement Long-term debt Common stock Retained earnings Total liabilities and owners' equity Balance Sheet Liabilities and Owners' Equity Current liabilities Bank loan Accounts payable Current Maturity Long-Term Debt Accrued wages Total current liabilities 2018 5,000 4,000 1,000 750 126 124 43 80 16 2018 685 890 500 12 2,087 250 2,337 753 570 10 4 1,337 500 100 400 2,337 0 Iterations 2019F 2019F 2019 Assumptions 8 percent growth 75 percent of sales 20 percent of sales 10 percent interest 25 percent tax 25 percent dividend payout 60 days sales 72 day collection period 7 times turnover hold at 2018 level 10 depreciation per year plug, initially zero 60 days payable estimate hold at 2018 level 10 amortization per year hold at 2018 level previous RE+NI-divs Answer Formula Sheet Debt/Capitalization = Total debt/(Total equity + total debt) Payables deferral period= payables/cost of goods sold per day Inventory conversion period inventory/cost of goods sold per day Cash conversion cycle = inventory conversion period + days sales outstanding-pavables deferral period Current ratio Current assets/current liabilities Acid test, quick ratio = (current assets-inventory)/ current liabilities Days cash sales cash/(sales/365) Working capital current assets-current liabilities Debt-to-asset ratio (debt ratio) = Total debt/total assets Days sales outstanding account receivables/(sales/365) Gross profit margin = (sales-cost of goods sold)/sales Inventory turnover = Cost of goods sold/ending inventory Total liabilities = assets x (liabilities/assets) Shareholders' equity = total assets-total liabilities Payables period = accounts payable/(cost of goods sold/365) ROE = Net income / equity Gross profit= sales-cost of goods sold Three-factor DuPont = Net profit margin x asset turnover x financial leverage Profit margin = Net income/sales Cash conversion cycle = collection period + inventory processing period - payables period I Inventory processing period = 365/inventory turnover Retained earnings, retained earnings, + net income,-dividends, Financial leverage [equity multiplier] = assets/equity Total asset turnover = sales/assets Dividend payout=1-retention rate Retention rate = 1-dividend payout ROA= Net income / total assets ROICEBIT(1-tax rate)/(interest-bearing debt + equity) g=change in sales growth [(growth new/growth old)-1] Debt/Capitalization = Total debt/(Total equity + total debt) EBIT interest coverage [times interest earned] EBIT/interest expense EBITDA interest coverage = EBITDA/interest expense E=mc² Area = 1/3 xr²h NOPAT = EBIT(1-tax rate); Free cash flow = NOPAT-ANet PPE +/- ANet Operating Working Capital Net operating working capital = (Cash + A/R + Inventory)-(A/P + Accruals) Cost of carrying receivables = (DSO)x Average sales per day x (Variable cost ratio) x (Cost of funds) AP = change in gross profit-change in cost of carrying receivables - change in bad debt losses-change in cost of discounts
Expert Answer:
Related Book For
College Accounting Chapters 1-30
ISBN: 978-1259631115
15th edition
Authors: John Price, M. David Haddock, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
Use the income statement and balance sheet for Wal-Mart (see Appendix A) to gather the necessary information to calculate Wal-Marts Economic Value Added (EVA) for 2009 and 2008. Wal-Marts weighted...
-
The following income statement and balance sheet information are available for two firms, Firm A and Firm B. (a) Calculate the amount of dividends Firm A and Firm B paid using the information given....
-
Income statement and balance sheet data for Virtual Gaming Systems are provided below. Required: 1. Calculate the following risk ratios for 2015 and 2016: a. Receivables turnover ratio. b. Inventory...
-
Selecting the best-suited HVAC system depends on factors such as: cost and availability of the energy source; appliance or system efficiency; cost to purchase, install, and maintain the appliance or...
-
While an engineering manager may prefer to use CFAT estimates to evaluate the AW of a project, a financial manager may select AW of EVA estimates. Why are these preferences predictable?
-
Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departmentsMolding and Fabrication. It started, completed, and sold...
-
Explain the terms res ipsa loquitur and judicial notice rule.
-
Use the following information from separate companies a through f to compute times interest earned. Which company indicates the strongest ability to pay interest expense as it comes due? (Round...
-
Find the equation of the line with slope = -2 and passing through (3,-2). Write your equation in point- slope form y-y = m(x-x1) AND slope-intercept forms. point-slope form: slope-intercept form:...
-
Eric Brown is responsible for upgrading the wireless network for his employer. He has identified seven possible locations to install new nodes for the network. Each node can provide service to...
-
Question: A camper hangs a 22 kgkg pack between two trees, using two separate pieces of rope of different lengths, as shown in the figure below. (Figure 1) What is the tension in left rope? What is...
-
Darling Leasing is considering the lease to Major State University of a piece of equipment costing $350,000. The period of the lease will be 8 years. The equipment will be depreciated under MACRS...
-
Amy Weir had the following transactions during the 2021/22 tax year: Assessable business income $ 97,OOO Maintenance receivedfrom ex-spouse ...
-
Detail the meaning of the Rank Ordering Ethical Principle. The degree of agreement on ordering of ethical principles is unknown. There is the possibility for variability in individual hierarchies and...
-
What are the thermodynamic and kinetic factors governing the adsorption of gases on solid adsorbents in pressure swing adsorption (PSA) processes for gas separation, and how do they influence the...
-
On March 1, 2025, Swifty Corporation purchased land for an office site by paying $2748000 cash. Swifty began construction on the office building on March 1. The following expenditures were incurred...
-
A forward contract on gold with a delivery price of $500 per ounce. Possible spot prices at delivery date: $800, $700, $600, $500, $400, and $300. Using the payoff function, calculate the possible...
-
What are multinational corporations (MNCs) and what economic roles do they play?
-
What two variances make up the total labor variance?
-
How does the balance sheet of a partnership differ from that of a sole proprietorship?
-
The board of directors of Roma Company authorized issuance of $1,000,000 of 5 percent bonds. Each bond has a face value of $10,000. The interest is payable semiannually on February 1 and August 1....
-
A layer of water is flowing down a flat plate that is inclined at an angle of $20^{\circ}$ to the vertical. If the depth of the layer is $1 / 4 \mathrm{in}$., what is the shear stress exerted by the...
-
A slider bearing consists of a sleeve surrounding a cylindrical shaft that is free to move axially within the sleeve. A lubricant (e.g., grease) is in the gap between the shaft and the sleeve to...
-
By making use of the analogies between the various transport models for molecular transport of conserved quantities, describe how you would set up an experiment to solve each of the following...
Study smarter with the SolutionInn App