Question

In: Finance

The latest income statement, balance sheet and other related information for ABC Company is as follows:...

The latest income statement, balance sheet and other related information for ABC Company is as follows:

Net Sales Revenue = $1,000,000

COGS = $600,000 (60% of Sales)

Operating Expenses = $200,000 (20% of Sales)

Interest Expense = $20,000 (10% of Long Term Debt)

Tax Expense = $54,000 (30% of Earnings Before Taxes)

Net Income = $126,000

Addition to Retained Earnings = $88,200 (70% of Net Income)

Current Assets = $700,000 (70% of Sales)

Net Fixed Assets = $900,000 (90% of Sales)

Current Liabilities = $200,000 (20% of Sales)

Long Term Debt = $200,000 (n/a)

Common Stock = $300,000 (n/a)

Retained Earnings = $900,000 (n/a)

1. Given the existing information, the Sustainable Growth Rate is (please round up to the nearest integer percentage such as 8): %

From now on, please assume that the company's sales will grow at 8% for the following year. Estimate the following regarding the proforma statements.

2. The proforma EBIT is: $

3. The initial proforma Interest Expense estimation is: $

4. Assuming the same tax rate of 30%, the proforma net income is: $

5. Assuming the same plowback ratio of 70%, the proforma addition to retained earnings is: $

6. Assuming 100% capacity usage, the proforma TOTAL assets are: $

7. The proforma current liabilities are: $

8. The proforma retained earnings are: $

9. The External Financing Need is: $

10. Assuming the EFN will be fulfilled by increasing the LTD, the proforma LTD (to balance the balance sheet) is: $

11. With the updated LTD you just calculated, assuming a 10% interest rate, the corrected interest expense (end of first iteration) is: $

12. If the current capacity usage is at 80%, then the proforma net fixed assets are: $

Solutions

Expert Solution

Since there are multiple subparts, i will be answering the first 4 subparts.

1.Computation of sustainable growth rate:

Excel spread sheet:

Excel workings:

2. Computation of EBIT:

Excel spread sheet:

Excel workings:

3. Computation of initial proforma expense:

The interest expenses will remain same as $20,000 since there is no change in long term debt.

4. Computation of net income:

Excel spread sheet:

Excel workings:


Related Solutions

The latest income statement, balance sheet and other related information for ABC Company is as follows:...
The latest income statement, balance sheet and other related information for ABC Company is as follows: Net Sales Revenue = $1,000,000 COGS = $600,000 (60% of Sales) Operating Expenses = $200,000 (20% of Sales) Interest Expense = $20,000 (10% of Long Term Debt) Tax Expense = $54,000 (30% of Earnings Before Taxes) Net Income = $126,000 Addition to Retained Earnings = $88,200 (70% of Net Income) Current Assets = $700,000 (70% of Sales) Net Fixed Assets = $900,000 (90% of...
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             ...
Analyze the Balance Sheet and Income Statement for ABC Company. Come up with 6 questions for...
Analyze the Balance Sheet and Income Statement for ABC Company. Come up with 6 questions for the client that you would like to dig deeper into based on the change from 2016 to 2017. For each of the 6 questions, list audit steps you would take to check for material misstatements and would you allow you to eventually sign off on the audit report. Balance Sheet 12/31/2017 and 12/31/2016 Assets Liabilities 12/31/2017 12/31/2016 12/31/2017 12/31/2016 Current Assets Current Liabilities Cash...
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’...
Presented below is the latest income statement of ABC Ltd.:
Presented below is the latest income statement of ABC  Ltd.:        Sales.............................................................................    $380,000        Cost of goods sold........................................................      225,000        Gross profit....................................................................    $155,000        Operating expenses......................................................        85,000        Income before income taxes.........................................         70,000        Income taxes.................................................................        28,000        Net income....................................................................    $  42,000 In addition, the following information related to net changes in working capital is available:                                                                                                          Debit                   Credit        Cash..............................................................................       $12,000        Accounts receivable (net).............................................           8,000        Inventories.....................................................................                                   $19,400        Salaries payable (operating expenses)........................           6,000        Accounts payable..........................................................                                       9,000        Income tax payable.......................................................           3,000 ABC Ltd. also reports that depreciation expense for the...
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...
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...
The information that follows relates to GAP latest Balance Sheet (dated December 31, 2017). The figures...
The information that follows relates to GAP latest Balance Sheet (dated December 31, 2017). The figures are presented in Thousands of U.S. Dollars unless noted otherwise. Using the information presented below, prepare and present a properly formatted Balance Sheet. Present the Balance Sheet in any format you wish (T-account or report format) so long as it is professional looking and complete. Accounts Payable $16,670 Accumulated Depreciation/Amortization on PPE 27,250 Additional Paid-in-Capital 46,400 Allowance for Doubtful accounts 350 Cash 110,325 Common...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT