Question

Use the financial statements for The Company to answer the questions that follow. The Company Income Statement and Balance Sheet Year t+1 Year t 7.400,051 7,069,736 7.045 359 6,749 700 320,036 190,669 45,681 83,686 23,948 59,738 354,692 193,558 Pre-tax Income Net Income Cash and Securities 49,243 69,229 292,062 328,060 603,545 546,940 1386,097 1412320 2,281,704 2,287,320 1,058,789 1,049,505 681,543 671,996 4,022,036 4,008,821 Flxed assets Goodwill & Intangibles Total Assets 671,996 Short-term borrowings Accounts 126,745 415,350 520,581 226,370 417,376 Current liabilities Long-term debt Common stock Retained earnings 1,062,676 1,099,445 794,322 608,712 1,481,593 1,482,444 1,482,444 683.445 2.165,038 2,200,664 Liabilities and Equity Price (in dollars) Shares $14.7 69.481 Prepare pro forma financial statements for The Company. The pro forma me statement and balance sheet) will be for the year ending Year t+1, based on the Year t historic financial statements. Use the percent of sales method based on Year t figures, and make the following assumptions: I. Assume a sales increase of 5%. 2. Taxes are 29% 3. Capital expenditures in Year t+ 1 are forecast to be $190,605 4. The depreciation rate is 15% 5. Dividends are zero in Year t+1. 6. Long-term debt is the plug variable. 7. The following accounts are the same in Year t+1 as in Year t: Goodwill & Intangibles, Common Stock
answers are provided! i need the calculations for ALL questions

Answer 1

Answer to 34,35,36 and 37 is explained below in this table. In case of any clarification please let us know.

Particulars	t-1	t	% of Sales	t+1	% of Sales	remarks
revenue	7400051	7069736	5%	7423223	5%	Percentage of sales
expenses	7045359	6749700	95%	7087185	95%	Percentage of sales
operating income	354692	320036	5%	336037.8	5%	Percentage of sales
depreciation	193558	190669	15%	186016.5		% is fixed at 15% of Fixed Assets opening balance and addition
interest	42662	45681	0.6%	41417	0.6%	Percentage of sales
pre tax income	118472	83686	1%	108604.3	1%	Percentage of sales
income tax	49243	23948	29%	31495.25		rate is fixed
net income	69229	59738	1%	77109.05	1%
cash and securities	292062	328060	5%	344463	5%	Percentage of sales
accounts receivable	603545	546940	8%	574287	8%	Percentage of sales
inventories	1386097	1412320	20%	1482936	20%	Percentage of sales
current assets	2281704	2287320	32%	2401686	32%	total of current assets
fixed assets	1058789	1049505		1054094		depreciation deducted and capital exp added
goodwill and intangibles	681543	671996		671996		remains same
total assets	4022036	4008821	57%	4127776	56%
short term borrowings	126745	226370	3%	237688.5	3%	Percentage of sales
accounts payable	415350	417376	6%	438244.8	6%	Percentage of sales
other	520581	455699	6%	478484	6%	Percentage of sales
current liabilities	1062676	1099445	16%	1154417	16%	total of current liabilities
long term debt'	794322	708712		806903		Difference of long term debt is plug in and diff comes to
common stock	1481593	1482444		1482444		it is remain same as per the question
retained earnings	683445	718220	10%	684011.3	9%
shareholder equity	2165038	2200664	31%	2166455	29%
liability and equity	4022036	4008821	57%	4127776	56%