Question

In: Finance

The Income statement and Balance Sheet for Day Light Robbery Inc. is given as follows: INCOME...

The Income statement and Balance Sheet for Day Light Robbery Inc. is given as follows: INCOME STATEMENT Sales $5,650,000 COGS 3,865,000 Depreciations 650,100 EBIT 1,134,900 Interest Expense 325,000 Taxable Income 809,900 Taxes 161,980 Net Income 647,920 Dividends $ 259,168 BALANCE SHEET ASSETS LIABILITIES & OWNERS EQUITY Current Assets 1,251,000 Current Liabilities 975,000 Long Term Debt 900,000 Net Fixed Asset 8,734,000 Common Stock 6,975,000 Accumulated Retained Earnings 1,135,000 Total Owner’s Equity 8,110,000 Total Assets 9,985,000 Total Liabilities & Equity 9,985,000 The firm expects its Sales to grow 20% next year Calculate the external funds needed (EFN)

Solutions

Expert Solution

Calculate the external funds needed (EFN)

External funds required = [(Assets / Sales) x Δ sales] - [(Spontaneous liabilities / Sales) x Δ sales] - [(Projected sales x Profit margin) x (1-Dividend payout ratio)]

=(9,985,000/5,650,000)*5,650,000*20%-(975,000/5,650,000)*5,650,000*20%-5,650,000*120%*11.47%*(1-40%)

= 1996999.99- 194999.99- 466599.6

External Funds Needed (EFN) =$ 1335400

Workings:
Net profit margin = 647920/5650000 = 11.47%
Dividend payout ratio = 259168/647920 = 40.00%
INCOME STATEMENT Current Year Basis for projections Next Projections before raising AFN
Sales $ 5,650,000 +20% $     6780000
Less: Costs $ 3,865,000 +20% $     4638000
Less: Depriciation $ 650,100 +20 $ 780120
Less: Interest $ 325,000 +20 $ 390000
Taxable income $ 809,900 +20 $ 971880
Taxes at 20% $ 161,980 +20 $ 194376
Net income $ 647,920 +20 $ 777504
Dividends (40%) $ 259,168 $ 311002
Addition to retained earnings (Net Income - Dividend) $ 388752 $ 466502
BALANCE SHEET
Current assets $ 1,251,000 +20 $ 1501200
Fixed assets-Net $ 8,734,000 +20 $ 10480800
Total assets $ 9,985,000 $ 11982000
Current Liabilities $ 975,000 +20 $ 1170000
Long term debt $ 900,000 $ 900000
Common stock $ 6,975,000 $ 6,975,000
Retained earnings $ 1,135,000 +466500 $ 1601500
Total Liabilities $ 9,985,000 $ 10646500
EFN (TA-TL) $ 1335400

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

LAG Network Inc.’s balance sheet and income statement are as follows: LAG Network Inc. Income Statement...
LAG Network Inc.’s balance sheet and income statement are as follows: LAG Network Inc. Income Statement For Year Ended December 31, 2017   Sales $ 933,600   Cost of goods sold 561,200   Gross profit $ 372,400   Operating expenses:      Depreciation expense $   25,200      Other expenses 241,800         Total operating expenses 267,000   Profit from operations $ 105,400   Income taxes 23,600   Profit $ 81,800 LAG Network Inc. Comparative Balance Sheet Information December 31   Assets 2017 2016   Cash $ 81,240 $ 55,400   Accounts receivable 47,400 38,600...
LAG network inc. balance sheet and income statement are as follows LAG network inc. income statemment...
LAG network inc. balance sheet and income statement are as follows LAG network inc. income statemment for year ended dec. 31 2020 sales                                             922600 cogs                                               550200 gross profit                                     $ 372400 operating expenses: depreciation expense    25200 other expenses                226800 total operating expenses                 252000 profit from operations                      $ 120400 invome taxes                                           12600 profit                                                       $107800              LAG network inc. comperative balance sheet information dec 31 assets                                    2020               2019 cash                                         81130        53200 acc. receviable                       40400       37200 merchandise inventory       283770       238600 equipment                              148400     137200 acc....
The balance sheet and income statement for Cruise Corporation are as follows:
The balance sheet and income statement for Cruise Corporation are as follows:                                                                                                                      Balance Sheet as of December 31, 2020                                                                                                                                ASSETS                                                                         LIABILITIES & EQUITY                          Cash & marketable securities $2,000             Accounts payable                    $30,000             Accounts Receivable               35,000             Taxes payable                         9,000             Inventory                                 15,000             Short-term borrowings           12,000             Total current assets                $52,000           Total current liabilities           $51,000             Net P,P & E                              $448,000         Long-term debt                       $200,000             TOTAL ASSETS                         $500,000         Total liabilities                        $251,000                                                                                     Common stock at par             $80,000                                                                                     Additional paid-in capital       $30,000                                                                                     Retained earnings                   $139,000                                                                         TOTAL LIABILITIES & EQUITY             ...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for the fiscal year ended January 30, 2020. For Fiscal Year Ended Jan. 30, 2020 ($ millions) Snap Golden Eagle Income statement information: Interest expense $236 $6 Income before interest and taxes 9,296 1,932 Balance sheet information: Cash and cash equivalents 7,946 1,534 Accounts receivable 1,692 478 Current assets 24,309 4,410 Current liabilities 15,971 2,691 Total assets 46,333 9,833 Total liabilities 30,554 3,422 Total stockholders’...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income Statement For Year Ended December 31, 2017   Sales $ 1,113,200   Cost of goods sold 568,000   Gross profit $ 545,200   Operating expenses:      Depreciation expense $ 50,000      Other expenses 307,360      Total operating expenses 357,360   Profit from operations 187,840   Loss on sale of equipment   13,080   Profit before taxes $ 174,760   Income taxes 28,760   Profit $ 146,000 ICE Drilling Inc. Comparative Balance Sheet Information December 31 2017 2016...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income Statement For Year Ended December 31, 2017   Sales $ 1,113,600   Cost of goods sold 570,000   Gross profit $ 543,600   Operating expenses:      Depreciation expense $ 52,000      Other expenses 307,760      Total operating expenses 359,760   Profit from operations 183,840   Loss on sale of equipment   13,480   Profit before taxes $ 170,360   Income taxes 29,160   Profit $ 141,200 ICE Drilling Inc. Comparative Balance Sheet Information December 31 2017 2016...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income Statement For Year Ended December 31, 2017   Sales $ 1,113,200   Cost of goods sold 568,000   Gross profit $ 545,200   Operating expenses:      Depreciation expense $ 50,000      Other expenses 307,360      Total operating expenses 357,360   Profit from operations 187,840   Loss on sale of equipment   13,080   Profit before taxes $ 174,760   Income taxes 28,760   Profit $ 146,000 ICE Drilling Inc. Comparative Balance Sheet Information December 31 2017 2016...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a...
Information from the Balance Sheet and statement of income are given below for Martinez Inc., a private company reporting under ASPE, for the year ended December 31. Martinez Inc. Comparative Balance Sheet, at December 31 2017 2016 Cash                                                                                 $92,150                $46,150 Accounts receivable 90,700                  36,150 Inventory                                                                           122,000                102,550 Investments in land 85,100                  107,150 Property, plant, and equipment 285,200                201,000 Accumulated depreciation (48,260)               (40,000)                                                                                         $626,890             $454,000 Accounts payable                                                             52,700                   48,410 Accrued liabilities                                                            ...
The balance sheet and income statement for the McDonald's are as follows. McDonald's Corporation 2016 Income...
The balance sheet and income statement for the McDonald's are as follows. McDonald's Corporation 2016 Income Statement ($ Millions) Sales $11,508 Cost of goods sold   6,537 Gross profits $ 4,971 Marketing expenses and general     and administrative expenses $ 1,832 Depreciation expense    345 Total operating expenses $ 2,177 Operating profits $ 2,794 Interest expenses      387 Earnings before taxes $ 2,407 Income taxes      765 Net income before preferred stock dividends $ 1,642 Preferred stock dividends        25 Net income available to common...
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows:...
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows: ($ millions) Ann Taylor Coach Inc Sales $2,212 $4,763 Cost of goods sold 1,004 1,297 Average accounts receivable 19 159 Average inventory 204 463 Average total assets 907 2,870 Required For each company, compute the following: Accounts receivable turnover Inventory turnover Asset turnover Interpret and comment on any differences you observe between the turnover rates for these two companies, i.e. for each ratio, which...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT