a.
To prepare: The financial statement of M Incorporation for the year ended 2016.
Additional Funds Needed (AFN) Equation:
The AFN equation explains the amount of money that a company needs to fulfill the financial needs of the company. It gives the information related to the external financing, as the options available to a company to finance through external financing methods. This equation basically gives a new capital structure that includes an optimum mix of debt, preferred and common stock.
Financial Statement:
The financial statement is
a.
Explanation of Solution
Prepare Income statement,
Table (1)
Prepare statement of retained earnings
Table (2)
Prepare Balance sheet
Table (3)
Working Notes:
Calculation of increase in sales:
Calculation of operating cost including depreciation
Calculation of the dividend amount:
Calculation of dividend payout ratio:
Calculation of AFN equation:
Calculation of the distribution of additional funds:
Calculation of interest on bonds:
Calculation of taxes:
Calculation of increase in cash:
Calculation of increase in receivables:
Calculation of increase in inventories:
Calculation of increase in fixed assets:
Calculation of notes payable:
Calculation of total liability:
Calculation of accrued liability:
Calculation of the amount of accounts payable:
Calculation of dividend of 2016:
b.
To compute: The growth in sales using AFN equation.
Additional Funds Needed (AFN) Equation:
The AFN equation explains the amount of money that a company needs to fulfill the financial needs of the company. It gives the information related to the external financing, as the options available to a company to finance through external financing methods. This equation basically gives a new capital structure that includes an optimum mix of debt, preferred and common stock.
Financial Statement:
The financial statement is final accounts of the company. Financial statement of the company contains the income statement, statement of retained earnings, balance sheet and cash flow statement.
b.
Explanation of Solution
Given:
Sales in 2015 is $3,600,000
Sales in 2016 is $3,960,000
Current liability at the end of 2015 is $596,000. It includes $360,000 of accounts payable, $56,000 of notes payable, and $180,000 of accrued liability
Forecasted retention ratio is 60%.
The formula to calculate the additional funds is:
Where,
Substitute $2,700,000 for current assets, $3,600,000 for current sales, $3,960,000 for expected sales, assume growth rate of sales is g
Thus, the growth in sales of M Incorporation is $135,384.615.
Want to see more full solutions like this?
Chapter 17 Solutions
Fundamentals of Financial Management (MindTap Course List)
- Consider the following financial data for Nguyen Industries: Statement of Financial Position as of December 31, 2018 Cash $ 232,500 Accounts payable $ 86,500 Accts. receivable 357,500 Short-term bank note 254,000 Inventories 150,500 Accrued wages & taxes 80,000 Total current assets $ 740,500 Total current liabilities $ 420,500 Long-term debt 566,000 Net fixed assets 774,500 Common equity 528,500 Total assets $ 1,515,000 Total liab. & equity $ 1,515,000 Profit & Loss Statement for 2018 Industry Average Ratios Net sales $ 1,894,000 Current ratio 1.4× Cost of goods sold 1,382,500 Quick ratio 1.0× Gross profit $ 511,500 Days sales outstanding 63 days Operating expenses 373,000 Inventory turnover 9.5× EBIT $ 138,500 Total asset turnover 1.5× Interest expense 64,000 Net…arrow_forwardThe following information relates to Basic Lid. for the year ended 31" December 2021: Net working capital RO. 1.200.000 Fixed assets to proprietor's fund ratio 0.75 Working capital turnover ratio 5 timeg Return on Equity 15% Current liabilities RO. 400.000 Long term Debts 0 You are required to calculate: Proprietor's funds Fixed Assets Current assets Net profit ratio Current ratioarrow_forwardBelow is the Statement of Financial Position for Rafah Islamic Bank: RAFAH ISLAMIC BANK STATEMENT OF FINANCIAL POSITION FOR THE YEAR ENDED 31 DECEMBER 2020 Assets RM Non current Asset 5,670,000 Long Term Investment 654,000,000 Financing (Net) 1,244,000,000 Corporate Bond Investment 919,094,000 Commercial Securities Investment 389,543,000 Deposits in other financial institutions 487,043,700 Other current assets…arrow_forward
- Given the following Year 9 selected balance sheet data: Assets Cash on Hand $136,000 255,000 230,000 $485,000 Total Current Assets Total Fixed Asset Investments Total Assets Liabilities and Shareholder Equity Accounts Payable Overdraft Loan Payable 1-Year Bank Loan Payable Current Portion of Long-Term Loans Total Current Liabilities $ 66,000 10,000 17,000 93,000 46,000 139,000 Long-Term Bank Loans Total Liabilities Year 8 Year 9 Shareholder Equity: Balance Change Common Stock (at a par value of $0.50 per share Additional Capital Retained Earnings Total Shareholder Equity Total Liabilities and Shareholder Equity 10,050 81,500 162,450 254,000 10,050 81,500 254,450 346,000 $485,000 92,000 +92,000 Based on the above figures and the definition of the debt:equity percentages (or debt%:equity%) presented in the Help section for p. 5 of the Camera and Drone Journal, the company's debt:equity percentages (rounded to 2 decimal places) and its current ratio are: Copyright © by Glo-Bus Software,…arrow_forwardRatio Analysis Rising Stars Academy provided the following information on its 2019 balance sheet and state mcnt of cash flows: Long-term debt S 4,400 Interest expense S 398 Total liabilities 8,972 Net income 559 Total assets 38,775 Interest payments 432 Total equity 29,803 Cash flows from operations 1.015 Operating income 1.223 Income tax expenses 266 Income taxes paid 150 Required: Calculate the following ratios for Rising Stars: (a) debt to equity, (b) debt to total assets, (c) long-term debt to equity, (d) times interest earned (accrual basis), and (e) times interest earned (cash basis). (Note: Round answers to three decimal places.) CONCEPTUAL CONNECTION Interpret these results. 3.What does it mean if a bond is callablearrow_forwardRosnan Industries' 2018 and 2017 balance sheets and income statements are shown below. Balance Sheets: 2018 2017 Cash and equivalents $120 $105 Accounts receivable 275 300 Inventories 375 350 Total current assets $770 $755 Net plant and equipment 2,000 1,490 Total assets $2,770 $2,245 Accounts payable $150 $85 Accruals 75 50 Notes payable 170 195 Total current liabilities $395 $330 Long-term debt 450 290 Common stock 1,225 1,225 Retained earnings 700 400 Total liabilities and equity $2,770 $2,245 Income Statements: 2018 2017 Sales $2,000 $1,500 Operating costs excluding depreciation 1,250 1,000 EBITDA $750 $500 Depreciation and amortization 100 75 EBIT $650 $425 Interest 62 45 EBT $588 $380 Taxes (40%) 235 152 Net income $353 $228 Dividends paid $53 $48 Addition to retained earnings $300 $180…arrow_forward
- Seminole Corporation reported the following items at December 31, 2021, and 2020: (Click the icon to view the comparative financial information.) Read the requirements. Requirement 1. Compute the company's (a) quick (acid-test) ratio and (b) days' sales outstanding for 2021. Evaluate each ratio value as strong or weak. All sales are on account with terms of net 30 days. (a) Enter the formula and calculate the quick (acid-test) ratio for 2021. (Abbreviation used: Cash* = Cash and cash equivalents. Round your final answer to two decimal places.) Cash* + Short-term investments + Net current receivables + Total current liabilities = Quick (acid-test) ratio $ Seminole's quick (acid-test) ratio is considered fairly weak. (b) Select the formula and calculate Seminole's days' sales outstanding for 2021. (Round interim calculations to two decimal places, XX.XX. Round the days' sales outstanding up to the next whole day.) Accounts receivable turnover = + Days' sales outstanding Seminole's days'…arrow_forwardCompute Net Cash flow from Financing Activities Balance Sheets for the Years Ending Dec. 31, 2011 and 2012 2012 2011 300 Cash Accounts receivable 400 1,000 3,200 4,500 3,800 8,300 400 700 1,400 3,000 4,800 4,300 9,100 Inventories Current assets Net fixed assets Total assets Notes payable Accounts payable 300 500 Аccruals 50 80 Current portion of long-term debt Current liabilities 70 80 960 1,220 4,300 1,200 680 Long-term debt Common stock ($.20 par) Additional paid-in capital Retained earnings Total liabilities and equity Net income (as reported on the 2012 Income statement) = 436 Depreciation (as reported on the 2012 Income statement) = 225 4,900 1,300 740 1,200 9,100 900 8,300arrow_forwardConsider the following financial data for Terry Enterprises: Balance Sheet as of December 31, 2018 Cash $ 86,000 Accounts payable $ 15,500 Accts. receivable 91,500 Notes payable 93,500 Inventories 65,500 Accruals 19,500 Total current assets $ 243,000 Total current liabilities $ 128,500 Long-term debt 162,500 Net plant & equip. 419,500 Common equity 371,500 Total assets $ 662,500 Total liab. & equity $ 662,500 Statement of Earnings for 2018 Industry Average Ratios Net sales $ 642,500 Current ratio 2.2× Cost of goods sold 482,000 Quick ratio 1.7× Gross profit $ 160,500 Days sales outstanding 44 days Operating expenses 119,500 Inventory turnover 6.7× EBIT $ 41,000 Total asset turnover 0.6× Interest expense 14,500 Net profit margin 7.2% Pre-tax earnings $ 26,500…arrow_forward
- JUST DEW IT CORPORATION2017 and 2018 Balance Sheets Assets Liabilities and Owners' Equity 2017 2018 2017 2018 Current assets Current liabilities Cash $ 10,150 $ 10,350 Accounts payable $ 74,500 $ 61,250 Accounts receivable 27,100 27,250 Notes payable 48,500 49,250 Inventory 62,900 63,500 Total $ 123,000 $ 110,500 Total $ 100,150 $ 101,100 Long-term debt $ 59,400 $ 64,900 Owners' equity Common stock and paid-in surplus $ 80,000 $ 80,000 Fixed assets Retained earnings 171,750 192,700 Net plant and equipment $ 334,000 $ 347,000 Total $ 251,750 $ 272,700 Total assets $ 434,150 $ 448,100 Total liabilities and owners' equity $ 434,150 $ 448,100 Based on the balance sheets given for Just Dew It, calculate the following…arrow_forwardPreparing the Cash Flow from Financing Activities Section Gomez Corp. reported the following items for the year ended December 31, 2020. Item Dec 31, 2020 Purchased an investment in debt securities (long-term) for cash $ 42,000 Sold equipment for cash, previously used in operations 35,000 Paid cash for dividends 14,000 Issued common stock for cash 140,000 Retired a 10-year bond payable by repaying the face value at maturity 112,000 Sold investment in equity securities (held for one-year) 15,400 Borrowed cash by signing a nine-month note payable 21,000 Extended a loan to a customer for a building expansion 11,200 Use a negative sign with your answer to indicate a cash outflow, if applicable. Calculate net cash from financing activities for the year ended December 31, 2020. Answerarrow_forwardConsider the following balance sheet and income statement for Metro Eagle Outfitters, in condensedform, including some information from the cash flow statement:Balance Sheet 2019 2018 2017Cash and short-term investments $ 630,992 $ 745,044 $ 734,693Accounts receivable 46,321 40,310 36,721Inventory 332,452 367,514 301,208Other current assets 132,035 134,620 101,788Total current assets 1,141,800 1,287,488 1,174,410Long-lived assets 582,832 647,482 593,802Total assets $ 1,724,632 $ 1,934,970 $ 1,768,212Current liabilities $ 432,902 $ 405,401 $ 387,837Total liabilities 503,445 517,786 417,141Shareholders’ equity 1,221,187 1,417,184 1,351,071Total debt and equity $ 1,724,632 $ 1,934,970 $ 1,768,212Income StatementSales $ 3,475,802 $ 3,120,065 $ 2,945,294Cost of sales 2,085,480 1,975,471 1,763,143Gross margin $ 1,390,322 $ 1,144,594 $ 1,182,151Operating expenses 988,284 869,385 864,776Earnings before interest and taxes $ 402,038 $ 275,209 $ 317,375Net income $ 232,108 $ 151,705 $…arrow_forward
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning
Cornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning