Garlington Technologies Inc.'s 2016 financial statements are shown below: Balance Sheet as of December 31, 2016 Cash $   180,000 Accounts payable $   360,000 Receivables 360,000 Notes...

Free

60.1K

Verified Solution

Question

Finance

Garlington Technologies Inc.'s 2016 financial statements areshown below:

Balance Sheet as of December 31, 2016

Cash$   180,000Accounts payable$   360,000
Receivables360,000Notes payable156,000
Inventories720,000Line of credit0
Total current assets$1,260,000Accruals180,000
Fixed assets1,440,000Total current liabilities$   696,000
Common stock1,800,000
Retained earnings204,000
Total assets$2,700,000Total liabilities and equity$2,700,000

Income Statement for December 31, 2016

Sales$3,600,000
Operating costs3,279,720
EBIT$  320,280
Interest18,280
Pre-tax earnings$  302,000
Taxes (40%)120,800
Net income181,200
Dividends$  108,000

Suppose that in 2017 sales increase by 15% over 2016 sales andthat 2017 dividends will increase to $192,000. Forecast thefinancial statements using the forecasted financial statementmethod. Assume the firm operated at full capacity in 2016. Use aninterest rate of 13%, 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
3.7 Ratings (619 Votes)

X Y=X/3600000
2016(actual) % of Sales 2017 (Forecast)
A Sales $3,600,000 100% $4,140,000 (3600000*1.15)
B Operating costs $3,279,720 91% $3,771,678 (91%*4140000)
C=A-B EBIT $320,280 9% $368,322
D Interest $18,280 1% $20,280 (156000*13%)
E=C-D Pre-tax earnings $302,000 8% $348,042
F=E*40% Taxes (40%) $120,800 3% $139,217
G=E-F Net income $181,200 5% $208,825
H Dividends: $108,200 3% $192,000
I=G-H Addition to RE: $73,000 2% $16,825
2016(Actual) 2017(Forecast)
Cash $180,000 $207,000 (180000*1.15)
Receivables $360,000 $414,000 (360000*1.15)
Inventories $720,000 $828,000 (720000*1.15)
Total current assets $1,260,000 $1,449,000
Fixed assets $1,440,000 $1,656,000 (1440*1.15)
Total assets $2,700,000 $3,105,000
Accounts payable $360,000 $414,000 (360000*1.15)
Notes payable $156,000 $463,175
Accruals $180,000 $207,000 (180000*1.15)
Total current liabilities $696,000 $1,084,175
Common stock $1,800,000 $1,800,000
Retained earnings $204,000 $220,825 (204000+16825)
Total liabilities and equity $2,700,000 $3,105,000
Additional Financing Need $307,175 (463175-156000)

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

Other questions asked by students