inancing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $Â Â Â 180,000 Accounts...

Free

80.2K

Verified Solution

Question

Finance

inancing Deficit
Garlington Technologies Inc.'s 2016 financial statements areshown below:
Balance Sheet as of December 31, 2016
Cash $Â Â Â 180,000 Accounts payable $Â Â Â 360,000
Receivables 360,000 Notes payable 156,000
Inventories 720,000 Line of credit 0
Total current assets $1,260,000 Accruals 180,000
Fixed assets 1,440,000 Total current liabilities $Â Â Â 696,000
Common stock 1,800,000
Retained earnings 204,000
Total assets $2,700,000 Total liabilities and equity $2,700,000
Income Statement for December 31, 2016
Sales $3,600,000
Operating costs 3,279,720
EBIT $Â Â 320,280
Interest 18,280
Pre-tax earnings $Â Â 302,000
Taxes (40%) 120,800
Net income 181,200
Dividends $Â Â 108,000
Suppose that in 2017 sales increase by 20% over 2016 sales andthat 2017 dividends will increase to $200,000. Forecast thefinancial statements using the forecasted financial statementmethod. Assume the firm operated at full capacity in 2016. Use aninterest rate of 8%, and assume that any new debt will be added atthe end of the year (so forecast the interest expense based on thedebt balance at the beginning of the year). Cash does not earn anyinterest income. Assume that the all new-debt will be in the formof a line of credit. Round your answers to the nearest dollar. Donot round intermediate calculations.
Garlington Technologies Inc.
Pro Forma Income Statement
December 31, 2017
Sales $
Operating costs $
EBIT $
Interest $
Pre-tax earnings $
Taxes (40%) $
Net income $
Dividends: $
Addition to RE: $

Garlington Technologies Inc.
Pro Forma Balance Statement
December 31, 2017
Cash $
Receivables $
Inventories $
Total current assets $
Fixed assets $
Total assets $
Accounts payable $
Notes payable $
Accruals $
Total current liabilities $
Common stock $
Retained earnings $
Total liabilities and equity $

Answer & Explanation Solved by verified expert

4.5 Ratings (816 Votes)

Income Statement
	2016		Forecast 2017
Sales	$Â Â 36,00,000	+20%	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 43,20,000
Operating costs	$Â Â 32,79,720	91.10% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 39,35,664
EBIT	$Â Â Â Â 3,20,280		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 3,84,336
Interest	$Â Â Â Â Â Â Â 18,280	$156000*58%	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 12,480
Pre-tax earnings	$Â Â Â Â 3,02,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 3,71,856
Taxes (40%)	$Â Â Â Â 1,20,800		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 1,48,742
Net income	$Â Â Â Â 1,81,200		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 2,23,114
Dividends:	$Â Â Â Â 1,08,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 2,00,000
Addition to RE:	$Â Â Â Â Â Â Â 73,200		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 23,114

Balance Statement
	2016		Forecast 2017
Cash	$Â Â Â Â 1,80,000	5% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 2,16,000
Receivables	$Â Â Â Â 3,60,000	10% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 4,32,000
Inventories	$Â Â Â Â 7,20,000	20% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 8,64,000
Total current assets	$Â Â 12,60,000	35% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 15,12,000
Fixed assets	$Â Â 14,40,000	40% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 17,28,000
Total assets	$Â Â 27,00,000	75% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 32,40,000
Accounts payable	$Â Â Â Â 3,60,000	10% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 4,32,000
Notes payable	$Â Â Â Â 1,56,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 1,56,000
Line of credit		AFN	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 4,08,886
Accruals	$Â Â Â Â 1,80,000	5% of sales	$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 2,16,000
Total current liabilities	$Â Â Â Â 6,96,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 12,12,886
Common stock	$Â Â 18,00,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 18,00,000
Retained earnings	$Â Â Â Â 2,04,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â 2,27,114
Total liabilities and equity	$Â Â 27,00,000		$Â Â Â Â Â Â Â Â Â Â Â Â Â Â 32,40,000

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Cash	$Â Â Â 180,000	Accounts payable	$Â Â Â 360,000
Receivables	360,000	Notes payable	156,000
Inventories	720,000	Line of credit	0
Total current assets	$1,260,000	Accruals	180,000
Fixed assets	1,440,000	Total current liabilities	$Â Â Â 696,000
		Common stock	1,800,000
		Retained earnings	204,000
Total assets	$2,700,000	Total liabilities and equity	$2,700,000

Sales	$3,600,000
Operating costs	3,279,720
EBIT	$Â Â 320,280
Interest	18,280
Pre-tax earnings	$Â Â 302,000
Taxes (40%)	120,800
Net income	181,200
Dividends	$Â Â 108,000

Garlington Technologies Inc. Pro Forma Income Statement December 31, 2017
Sales		$
Operating costs		$
EBIT		$
Interest		$
Pre-tax earnings		$
Taxes (40%)		$
Net income		$
Dividends:		$
Addition to RE:		$

Garlington Technologies Inc. Pro Forma Balance Statement December 31, 2017
Cash		$
Receivables		$
Inventories		$
Total current assets		$
Fixed assets		$
Total assets		$
Accounts payable		$
Notes payable		$
Accruals		$
Total current liabilities		$
Common stock		$
Retained earnings		$
Total liabilities and equity		$

inancing Deficit Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $Â Â Â 180,000 Accounts...

Free

80.2K

Verified Solution

Question

Finance

Answer & Explanation Solved by verified expert

Get Answers to Unlimited Questions

Membership Benefits:

Other questions asked by students