Question

Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion...

Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion method to answers question (1) and (2). To do this assume that the percentage values with respect to sales of the (i) costs except depreciation, (ii) cash and equivalents, (iii) accounts receivable, (iv) inventories, and (v) accounts payable will stay fixed at the values corresponding for 2016.

Assume also that income tax will remain at 35% of the Pretax Income.

Consider Company Y. This firm sells a product for which in 2016 the total market size was of 1999000 units, of which Company Y owned a share of 30%.

Both, the total market size and Company Y’s market share are expected to grow at a 4% yearly rate for the next five years.

The price of the product is $114 in 2016 and is expected to remain at that price for the next years.

Market Analysis

2016

2017

2018

2019

Market Size

1,999,000

2,078,960

2,162,118

2,248,603

Market Share

30%

31%

32%

34%

Production Volume

     599,700

Sales Price:

$   114.00

Sales

In 2016, the outstanding debt of Company Y is $900000, for which the company makes yearly interest payments of 11%. The executives of Company Y are considering making a significant capital investment in 2017 of $2900000 to purchase new machinery. The company plans to finance this investment with a 30-year loan that makes yearly interest payments equivalent to 8% of its principal. The principal is paid when the loan matures.

The following table summarizes the debt and interest payment of Company Y.

Debt and Interest Table

2016

2017

2018

Outstanding Debt

900,000

900,000

3,800,000

New Net Borrowing

2,900,000

Interest on Debt

Currently, Company Y makes yearly expenditures on replacement capital investment of $90000. If the company makes the planned expansion it is decided the company will perform yearly expenditures on replacement capital investment of $325000. The current and the planned expenditures on replacement of capital investment will be financed by the company’s cash flow.

The following table indicates for 2016 Company Y’s values of i. opening book value, ii. capital investment, iii. depreciation, and iv. closing book value. The Table also indicates the 2017-2018 forecast values of capital depreciation if the planned expansion were to occur in 2017.

Fixed Assets & Capital Investment

2016

2017

2018

Opening Book Value

1,500,000

Capital Investment

90,000

Depreciation

-127,200

-356,224

-353,726

Closing Book Value

1,462,800

The following table contains Company Y’s income statement.

Income Statement:

2016

2017

Sales

68,365,800

Costs except Depr.

-5,469,264

EBITDA

62,896,536

Depreciation

-127,200

EBIT

62,769,336

Interest Expense (net)

-99,000

Pretax Income

62,670,336

Income Tax

-21,934,618

Net Income

40,735,718

The following table contains Company Y’s balance sheet.

Balance Sheet

2016

2017

Assets

Cash and Equivalents

23,928,030

Accounts Receivable

23,928,030

Inventories

10,254,870

Total Current Assets

58,110,930

Property Plant and Equipment

1,462,800

Total Assets

59,573,730

Liabilities and Equity

Accounts Payable

23,928,030

Total Current Liabilities

23,928,030

Debt

900,000

Total Liabilities

24,828,030

Stockholders' Equity

Starting Stockholders' Equity

8,000,000

Net Income

40,735,718

Dividends

-13,990,018

Stockholders' Equity

34,745,700

Total Liabilities & Equity

59,573,730

1.      Before making any adjustments to balance Total Assets with Total Liabilities and Equity, what is Company Y s forecast value of Total Liabilities and Equity for 2017?"

2.      How much are the net new financing for Company Y s on 2017?

For question one i know the answer is 108,349,142 and question 2 answer is -41,399,784. but how do i get those answers. im having diffculty acheiving the correct answers. Can someone please show the steps.

Homework Answers

Answer #1
Forecasted Income Statement
For the year 2017
Sales (2,078,960*31.2% *114) 73944449.28
Cost except Depreciation (8% of sales) -5915555.94
EBITDA 68028893.34
Depreciation -356224
EBIT 67672669.34
Interest Expenses (900000*11% + 2900000*8%) -331000
Pretax Income 67341669.34
Income Tax (35%) -23569584.23
Net Income 43772085.11
Forecasted Balance Sheet
For the year 2017
Assets
    Cash and Equivalents (35% of sales) 25880557.25
     Accounts Receivables (35% of sales) 25880557.25
     inventories (15% of sales) 11091667.39
    PPE (1462800 +325000 - 356224) 1431576
                                      TOTAL ASSETS 64284357.9
Liabilities and Equity
      Accounts payable (35% of Sales) 25880557.25
      Debt (900000 + 2900000) 3800000
      Stockholders's Equity 8000000
     Retained Earnings (40735718 - 13990018 + 43772085.11) 70517785.11
     Dividends
                                    TOTAL LIABILITIES AND EQUITY 108198342

Before adjusting the laibilities and shareholder equity for dividend paid to balance the asset with liabilities, Total liabilities and shareholder's equity for 2017 amounted to $108,198,342.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider a company with the following financial statement information:                               &nb
Consider a company with the following financial statement information:                                   Balance Sheet Cash $140,000                                            Accounts payable $200,000 Marketable securities 200,000                       Wages payable 100,000 Accounts receivable 40,000                            Short-term debt 250,000 Inventory 1,000,000                                        Long-term debt 690,000 Fixed assets 900,000                                    Total liabilities $1,240,000                                                                     Common stock 950,000                                                                                                       Retained earnings 90,000 Total assets $2,280,000                                 Total equity & liabilities $2,280,000 Income Statement Sales $1,200,000 Cost of goods sold $400,000 Amortization $90,000 Interest $56,400 Earnings before taxes $653,600 Taxes $261,440 Net income $392,160 Shares outstanding...
Toth Company had the following assets and liabilities on the dates indicated. December 31 Total Assets...
Toth Company had the following assets and liabilities on the dates indicated. December 31 Total Assets Total Liabilities 2016 $469,000 $216,000 2017 $549,000 $266,000 2018 $679,000 $366,000 Toth began business on January 1, 2016, with an investment of $95,000 from stockholders. From an analysis of the change in stockholders’ equity during the year, compute the net income (or loss) for: (a) 2016, assuming Toth paid $25,000 in dividends for the year. Net income (loss) for 2016: (b) 2017, assuming stockholders...
Use the following information to answer this question. Thomas Company 2017 Income Statement ($ in millions)...
Use the following information to answer this question. Thomas Company 2017 Income Statement ($ in millions) Net sales $ 9,530 Cost of goods sold 7,760 Depreciation 465 Earnings before interest and taxes $ 1,305 Interest paid 104 Taxable income $ 1,201 Taxes 420 Net income $ 781 Thomas Company 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 230 $ 260 Accounts payable $ 1,370 $ 1,385 Accounts rec. 1,000 900 Long-term debt 1,100 1,300...
This experiential exercise involves creating a pro forma Balance Sheet and a pro forma Income Statement...
This experiential exercise involves creating a pro forma Balance Sheet and a pro forma Income Statement for XYZ Company. Assume the current year is 2015. To assist you in this endeavor, an Excel worksheet containing XYZ’s 2014 Income Statement and Balance Sheet has been provided. Develop the two pro forma financial statements for 2015 based upon the following assumptions:      The company plans to increase sales by an additional 2 percent in 2015 due to minor price increases. In addition, the...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) &...
Use the following Income Statement and Balance Sheet of firm X to answers Questions (1) & (2) Income Statement, 2016 Balance Sheet, 2016 Sales 5,000,000 Assets Costs except Depr. -3,500,000 Cash and Equivalents 1,096,000 EBITDA 1,500,000 Accounts Receivable 960,000 Depreciation -10,900 Inventories 90,000 EBIT 1,489,100 Total Current Assets 2,146,000 Interest Expense (net) -100,500 Property Plant & Equipment 2,190,000 Pretax Income 1,388,600 Total Assets 4,336,000 Income Tax -486,010 Liabilities &Equity Net Income 902,590 Accounts Payable 900,000 Debt 950,000 Total Liabilities 1,850,000...
USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Mellon Company Balance Sheet For the...
USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Mellon Company Balance Sheet For the Years Ending December 31, 2017 and 2018 (All figures in dollars) 2017 2018 Cash 1,400 1,820 Accounts receivable 7,520 6,870 Inventory 6,450 7,180 Total current assets 15,370 15,870 Gross fixed assets 102,860 108,960 (Accumulated depreciation) (14,980) (16,470) Net fixed assets 87,880 92,490 Land 12,560 14,860 Total assets 115,810 123,220 Notes payable 1,870 1,960 Accounts payable 820 960 Accruals 480 380 Current portion of LT...
[The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company...
[The following information applies to the questions displayed below.] Selected comparative financial statements of Korbin Company follow. KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales $ 484,546 $ 371,202 $ 257,600 Cost of goods sold 291,697 233,486 164,864 Gross profit 192,849 137,716 92,736 Selling expenses 68,806 51,226 34,003 Administrative expenses 43,609 32,666 21,381 Total expenses 112,415 83,892 55,384 Income before taxes 80,434 53,824 37,352 Income tax expense 14,961 11,034 7,582...
Suppose a company had the following Financial Statement Information. Balance Sheet 2015 2015 (Revised) 2016 2016...
Suppose a company had the following Financial Statement Information. Balance Sheet 2015 2015 (Revised) 2016 2016 (Revised) 2017 2017 (Revised) Total CA 3700 3700 4000 4000 4200 4200 Fixed Assets 8800 8700 9000 Total Assets 12500 12700 13200 Total Current Liabilities 2500 2500 2800 2800 3100 3100 Total Non Current Liabilities 6500 6500 7200 Total Liabilities 9000 9300 10300 Total Stockholder Equity 3500 3400 2900 Total Liabilities and Equity 12500 12700 13200 Income Statement 2015 2015 (Revised) 2016 2016 (Revised)...
Use the following information to answer this question. Windswept, Inc. 2017 Income Statement ($ in millions)...
Use the following information to answer this question. Windswept, Inc. 2017 Income Statement ($ in millions) Net sales $ 8,950 Cost of goods sold 7,490 Depreciation 425 Earnings before interest and taxes $ 1,035 Interest paid 94 Taxable income $ 941 Taxes 329 Net income $ 612    Windswept, Inc. 2016 and 2017 Balance Sheets ($ in millions) 2016 2017 2016 2017 Cash $ 170 $ 200 Accounts payable $ 1,150 $ 1,285 Accounts rec. 880 780 Long-term debt 1,060...
Below you can find the comparative financial statements of company “ABC” in € for 2017 and...
Below you can find the comparative financial statements of company “ABC” in € for 2017 and 2018: Comparative Balance Sheet of “ABC” Assets 2018 2017 Liabilities & Stockholders’ Equity 2018 2017 Fixed Assets Property, Plant and Equipment Goodwill Other Assets Total Fixed Assets Current Assets Cash and Cash Equivalents Accounts receivables Inventory Prepaid Expenses Other current assets Total Current Assets Total Assets 53,000 14,200 9,520 76,720 1,500 11,600 15,300 540 280 29,220 105,940 56,000 14,200 10,240 80,440 1,660 14,000 14,820...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT