Question

In: Accounting

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?

Solutions

Expert Solution

Note:
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 644,478 691,878 764,525
Sales Price: $114 $114 $114 $114
Sales 68,365,800 73,470,492 78,874,092 87,155,850
Debt and Interest Table ROI 2016 2017
Outstanding Debt 11% 900,000 900,000
New Net Borrowing 8% 2,900,000
Interest on Debt 99,000 331,000
Fixed Assets & Capital Investment 2016 2017 2018
Opening Book Value 1,500,000 1,462,800 1,431,576
Capital Investment 90,000 325,000 325,000
Depreciation -127,200 -356,224 -353,726
Closing Book Value 1,462,800 1,431,576 1,402,850
The following table contains Company Y’s income statement.
Income Statement: 2016 2017
Sales 68,365,800 73,470,492
Costs except Depr. 8% -5,469,264 -5,877,639
EBITDA 62,896,536      67,592,853
Depreciation -127,200 -356,224
EBIT 62,769,336 67,236,629
Interest Expense (net) -99,000 -331,000
Pretax Income 62,670,336 66,905,629
Income Tax 35% -21,934,618         (23,416,970)
Net Income 40,735,718      43,488,659
The following table contains Company Y’s balance sheet.
Balance Sheet 2016 2017
Assets
Cash and Equivalents 35% 23,928,030 25,714,672
Accounts Receivable 35% 23,928,030 25,714,672
Inventories 15% 10,254,870 11,020,574
Total Current Assets 58,110,930 62,449,918
Property Plant and Equipment 1,462,800 1,431,576
Total Assets 59,573,730 63,881,494
Liabilities and Equity
Accounts Payable 35% 23,928,030 25,714,672
Total Current Liabilities 23,928,030 25,714,672
Debt 900,000 3,800,000
Total Liabilities 24,828,030 29,514,672
Stockholders' Equity
Starting Stockholders' Equity 8,000,000 34,745,700
Net Income 40,735,718 43,488,659
Dividends -13,990,018       (43,867,537)
Stockholders' Equity 34,745,700 34,366,822
Total Liabilities & Equity 59,573,730 63,881,494
Note: Dividends Taken as residual value
(1)What is Company Y’s forecast value of Total Liabilities and Equity for 2017 without any adjustment into balance
Total Assets for 2017 will be 63,881,494

Total Liabilities & Equity for 2017 will be 63,881,494 (from this dividend assumed to be paid 43,867,537)

2) Net new financing for Company Y’s on 2016: is 2,900,000

Related Solutions

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...
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...
Pro forma financial information: A) usually focsuses on pro forma earnings, usually on a non-GAAP basis...
Pro forma financial information: A) usually focsuses on pro forma earnings, usually on a non-GAAP basis b) is always presented on a generally accepted accounting principles (GAAP) basis c)is illegal d) is found in the statement of stockholders' equity Mandalay had cash flow from operations (in millions) of $358, cash flows from investments of -$160, cash flows from financing of -$198, and net income of $53. Mandalay had free cash flow of: a) $198 b) $160 c) $251 d)$0
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement...
Which of the following budgeted pro forma financial statements is prepared first? A. Pro forma statement of cash flows B. Pro forma income statement C .Pro forma balance sheet D. May be prepared in any order explain why please
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in...
Prepare the following Pro Forma Financial Statements for the proposed new location (pro forma statements in this case are budgeted statements for 2018 based on the new location scenario at the bottom of the page) Pro Forma Income Statement Pro Forma Balance Sheet PEYTON APPROVED PRO FORMA INFORMATION The company is planning to open another location in 2018 . Prepare pro forma financials for 2018 for the new location using the following information: 1. Cost of leasing commercial space: $1,500...
Discuss the impact of the pro forma financial statements for predicting ability to meet future expansion...
Discuss the impact of the pro forma financial statements for predicting ability to meet future expansion goals
Forecast the Pro forma Financial Statements for Company C using the % of Sales Method assuming:...
Forecast the Pro forma Financial Statements for Company C using the % of Sales Method assuming: sales increase by $100,000 in 2017; the company must increase Fixed Assets to $200,000 to support the higher level of production; all new financing will come from additional debt, and the payout ratio, the effective tax rate, and the rate of interest on debt will remain unchanged from 2016. Based on two iterations, what do you forecast for the amount of debt and the...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Phoebe's Cat Foods​ Inc.: Total asset turnover   1.6 times Average collection period (assume 365-day year)   16 days Fixed asset turnover   6 times Inventory turnover (based on cost of goods sold)   2 times Current ratio   2.0 times Sales (all on credit)   $3,000,000 Cost of goods sold   75% of sales Debt ratio   60% Fill in the assets section of the pro forma balance sheet....
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance...
​(Pro forma balance sheet construction​) Use the following​ industry-average ratios to construct a pro forma balance sheet for​ Karen's Beauty​ Products, Inc.: Total asset turnover 1.5 times Average collection period​ (assume 365-day​ year) 16 days Fixed asset turnover 6 times Inventory turnover​ (based on cost of goods​ sold) 2 times Current ratio 1.9 times Sales​ (all on​ credit) ​$5,000,000 Cost of goods sold 70​% of sales Debt ratio 40​% . Fill in the assets section of the pro forma balance...
Use the following information to create a pro forma balance sheet for General Talc Mines as...
Use the following information to create a pro forma balance sheet for General Talc Mines as of December 31, 2010. ASSETS Cash 25000 Accounts Receivable 120000 Inventories 300000 Total current assets 445000 Net Fixed Assets 500000 Total Assets 945000 LIABILITIES & STOCKHOLDERS EQUITY Equity accounts payable 80000 Notes Payable 350000 Accruals 50000 Total current liabilities 480000 Long-term debt 150000 Total Liabilities 630000 Common Stock 180000 Retained Earnings 135000 Total Stockholder's Equity 315000 Total Liabilities & Stockholders Equity 945000 A financial...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT