The most recent financial statements for Moose Tours, Inc., appear below. Sales
ID: 2819081 • Letter: T
Question
The most recent financial statements for Moose Tours, Inc., appear below. Sales for 2016 are projected to grow by 25 percent. Interest expense will remain constant; the tax rate and the dividend payout rate will also remain constant. Costs, other expenses, current assets, fixed assets, and accounts payable increase spontaneously with sales MOOSE TOURS, INC 2015 Income Statement Sales Costs Other expenses $746,000 581,000 17,000 Earnings before interest and taxes Interest expense $148,000 14,000 Taxable income Taxes (20%) $134,000 26,800 Net income $107,200 Dividends Addition to retained earnings $ 21,440 85,760 MOOSE TOURS, INC Balance Sheet as of December 31, 2015 Assets Liabilities and Owners Equity Current assets Current liabilities $ 54,700 Cash Accounts receivable Inventory $ 20,540 Accounts payable 32,860 Notes payable 69,820 13,900 $ 68,600 $129,000 Total Total $ 123,220 Long-term debt Fixed assets Owners' equity Common stock and paid-in surplus Retained earnings Net plant and equipment $462,000 $ 115,000 272,620 $ 387,620 $585,220 Total Total assets $ 585,220 Total liabilities and owners' equity If the firm is operating at full capacity and no new debt or equity is issued, what external financing is needed to support the 25 percent growth rate in sales? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.) External financing needed 22630Explanation / Answer
Moose Tours Inc. Dividend in percentage of Net Income in 2015=($21440/$107200)*100 20% Retained Earnings in percentage of Income=($85760/$107200)*100 80% 2015 2016 Sales(A) $ 7,46,000.00 746000*1.25 $ 9,32,500 Operating Cost(B) $ 5,81,000.00 581000*1.25 $ 7,26,250 Other Expenses=(C ) $ 17,000.00 17000*1.25 $ 21,250 EBIT(D )=(A)-(B)-(C ) $ 1,48,000.00 $ 1,85,000 Interest=(E ) $ 14,000.00 $ 14,000 EBT=(F )=(D )-(E ) $ 1,34,000.00 $ 1,71,000 Tax(G )=(20%)*(F) $ 26,800.00 $ 34,200 EAIT=(H)=(F )-(G) $ 1,07,200.00 $ 1,36,800 Dividend=(I) $ 21,440.00 136800*20% $ 27,360 Retained Earnings=(H)-(I) $ 85,760.00 $ 1,09,440 2015 2016 Assets Cash $ 20,540.00 20540*1.25 $ 25,675.00 Accounts Receivable $ 32,860.00 32860*1.25 $ 41,075.00 Inventories $ 69,820.00 69820*1.25 $ 87,275.00 Net Fixed Assets $ 4,62,000.00 462000*1.25 $ 5,77,500.00 Total Assets=(A) $ 5,85,220.00 $ 7,31,525 Liabilties Accounts Payable $ 54,700.00 54700*1.25 $ 68,375 Notes Payables $ 13,900.00 $ 13,900 Long Term debt $ 1,29,000.00 $ 1,29,000 Common Stock $ 1,15,000.00 $ 1,15,000 Retained Earnings $ 2,72,620.00 $ 3,82,060 Total Liabilities & Equity=(B) $ 5,85,220.00 $ - $ 7,08,335 AFN=(A)-(B) $ 23,190 In 2016 Note Payable= $ 37,090.00