Question

Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%,...

  1. Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%, and dividends are forecast to increase to $1.50 per share in 2019. Create the 2019 financial statements using the percent of sales method (not the AFN equation) assuming the firm is operating at full capacity in 2018. Any extra borrowing will be done with Notes Payable and excess funds will be used to pay down Notes Payable. Interest on all interest-bearing debt is 5% and is paid on the debt outstanding at the end of the prior year.

What is the AFN in 2019?

2018
Cash $100,000 Accounts Payable $       300,000
Marketable Securities            250,000 Accruals            250,000
Account Receivable            400,000 Notes Payable            500,000
Inventory            800,000
    Total Current Assets $1,550,000    Total Current Liabilities $    1,050,000
Net Property Plant & Equipment        2,500,000 Long-term Debt            750,000
Common Stock        1,500,000
Retained Earnings            750,000
Total Assets $4,050,000 Total Liabilities and Equity $    4,050,000
Income Statement
31-Dec-18
Sales $       5,000,000
Operating Costs           4,000,000
   EBIT           1,000,000
Interest                62,500
   EBT              937,500
Taxes (30%)              281,250
Net Income $          656,250
Number of shares outstanding            100,000
Dividends per share               $1.20
0 0
Add a comment Improve this question Transcribed image text
Answer #1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

Home nert Page Layout Formulas Data Review View dd-Ins s Cut aCopy Σ AutoSum ー E ゴWrap Text General в 1 프 . Ej-., Δ. : rーー 逻锂函Merge & Center. $, % , 弼,8 C Paste Conditional Format CeInsert Delete Format Formatting as Table Styles2 Clear Sort &Find & Format Painter Clipboard Font Alignment Number Styles Cells Edting IH436 IG 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 14 | YIELD SPOT IH IJ IK IL IM IN IO IP i0 IR 7% INCREASE SALES 5000000 5350000 4000000 4280000 OPERATING COSTS EBIT INTEREST EBT TAX NET INCOME DIVIDEND ADDITION TO RETAINED EARNINGS 1000000 1070000 62500 937500 1007500 281250 302250 656250 705250 62500 120000 150000 [-1.5*100000] 536250 555250 FORECASTED BALANCESHEET . . Sheet2 AFN BANKING . NO TE BIDDING, UNDERWRITING EUAC AW PM LIFE LP, Ip, MRP, INFLATION YIELD WARRAN Trefund bond CLEAN INVOICE PRICE erences: GC323 福 130% 07:59 01-02-2019Home nert Page Layout Formulas Data Review View dd-Ins Cut copy ▼ ー E ゴWrap Text er笛溜conditional Format hal ins. Dre Format Eutosumh A Formatting 1 as Table-styles . tga Paste チFormat Painter B l U. ㄧ˙ タ.Δ. -=- 還便困Merge & Center. $,%,,Ma conditional Format Cell Insert Delete Format 2 ClearFe Select Edting ▼ ㆆ ▼ Clipboard Font Alignment Number Cells IN450 IG 434 435 436 437 CASH 438 439 RECEIVABLES IK L IM IO IP RT IR FORECASTED BALANCESHEET TOTAL ASSETS CURRENT NEXT YEAR TOTAL LIABILITIES & EQUITY YEAR 100000 1070007% INCREASE 50000 267500 400000 4280007% INCREASE 800000 856000 7% INCREASE 300000 250000 500000 3210007% INCREASE 2675007% INCREASE 500000 ACCOUNTS PAYABLE ACCRUALS NOTES PAYABLE TOTAL AFN LONG TERM DEBT OWNERS EQUITY COMMON STOCK RETAINED EARNINGS TOTAL TOTAL LIABILITIES & EQUITY MARKETABLE SECURITIES INVS 1050000 1088500 441 TOTAL 442 443 NET FIXED ASSETS 1550000 16585007% INCREASE -310250 (BALANCING FIGURE) 50000 75000O 2500000 26750007% INCREASE 1500000 1500000 445 446 447 448 AFN FOR CURRENT YEAR-TOTAL ASSETS TOTAL EQUITY - LONG TERM DEBT CURRENT LIABILITIES 750000 1305250 (750000+555250) 2250000 2805250 TOTAL 4050000 4333500 7% INCREASE 4050000 4333500 AFN FOR CURRENT YEAR- 4333500 2805250-750000 1088500- 310250 450 451 ANS AFN=-310250 452 SPOT Sheet2 AFN BANKING NOTE BIDDING, UNDERWRITING ELACAN PILFE L I MRP INFLATION YIELD WARRANT eind bond CLEAN IVOCE PRICE rences: GB150 福 130% 08:01 01-02-2019

Add a comment
Know the answer?
Add Answer to:
Winter Technologies 2018 financial statements are shown below. 2019 Sales are forecast to grow by 7%,...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December...

    Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December 31, 2018 Cash $ 180,000 Accounts payable $ 360,000 Receivables 360,000 Notes payable 156,000 Inventories 720,000 Line of credit 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, 2018 Sales $3,600,000 Operating costs 3,279,720 EBIT $ 320,280 Interest 18,280 Pre-tax...

  • Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December...

    Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December 31, 2018 Cash $ 180,000 Accounts payable $ 360,000 Receivables 360,000 Notes payable 156,000 Inventories 720,000 Line of credit 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, 2018 Sales Operating costs $3,600,000 3,279,720 $ 320,280 18,280 EBIT Interest Pre-tax...

  • Last year's financial statements for Heller Carbonic are below. Sales are expected to grow by 20...

    Last year's financial statements for Heller Carbonic are below. Sales are expected to grow by 20 percent this year. Their tax rate is 35 percent and their retention ratio is expected to remain at 60 percent. Costs, selling and administration expense, current assets, accounts payable, and accrued taxes increase proportionally with sales Interest expense, notes payable, and long-term debt will be unchanged. Heller is operating at 85 percent capacity Income Statement Last Year Sales 1,250,000 750,000 250,000 250,000 125,000 125,000...

  • Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December...

    Financing Deficit Garlington Technologies Inc.'s 2018 financial statements are shown below: Balance Sheet as of December 31, 2018 $360,000 156,000 Cash Receivables Inventories Total current assets Fixed assets $ 180,000 Accounts payable 360,000 Notes payable 720,000 Line of credit $1,260,000 Accruals 1,440,000 Total current Kabilities Common stock Retained earnings $2,700,000 Total liabilities and equity 180.000 $ 696.000 1,800,000 204,000 Total assets $2.700.000 Income Statement for December 31, 2018 Sales Operating costs EBIT Interest Pre-tax earings Taxes (40%) Net income Dividends...

  • Using S&S Air financial statements for 2018 below, prepare proforma (forecast) for 2019 financial statements and...

    Using S&S Air financial statements for 2018 below, prepare proforma (forecast) for 2019 financial statements and calculate the External Financing Needed (EFN) for the company. S&S Air, Inc 2018 Income Statement Sales $46,298.115 Cost of goods sold 34,536,913 Other expenses 5,870.865 Depreciation 2074.853 $ 3.815.484 EBIT Interest 725.098 S 3,090.386 Taxable income 772 597 Taxes (21%) $ 2.317.799 Net income s 705,000 Dividends Add to retained earnings 1.612.789 S&S Air. Inc 2018 Balance Sheet Liabilities and Equity Assets Current assets...

  • Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of...

    Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2019 Cash $180,000 Accounts payable $360,000 Receivables 360,000 Notes payable 56,000 Inventories 720,000 Accrued liabilities 180,000 Total current assets $1,260,000 Total current liabilities $596,000 Long-term debt 100,000 Fixed assets 1,440,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Morrissey Technologies Inc.: Income Statement for December 31, 2019 Sales $3,600,000 Operating costs including depreciation 3,279,720 EBIT $320,280...

  • Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of...

    Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2019 Cash $180,000 Accounts payable $360,000 Receivables 360,000 Notes payable 56,000 Inventories 720,000 Accrued liabilities 180,000 Total current assets $1,260,000 Total current liabilities $596,000 Long-term debt 100,000 Fixed assets 1,440,000 Common stock 1,800,000 Retained earnings 204,000 Total assets $2,700,000 Total liabilities and equity $2,700,000 Morrissey Technologies Inc.: Income Statement for December 31, 2019 Sales $3,600,000 Operating costs including depreciation 3,279,720 EBIT $320,280...

  • show thw cell refference. Chapter 12. Financial Statement Forecasting Belize Diving Company's 2019 financial statements are...

    show thw cell refference. Chapter 12. Financial Statement Forecasting Belize Diving Company's 2019 financial statements are shown below. Forecast Cozumel Diving's 2020 income statement and balance sheets. Use the following assumptions: (1) Sales grow by 15%. (2) The ratios of expenses to sales, depreciation to fixed assets, cash to sales, accounts receivable to sales, and inventories to sales will be the same in 2019 as in 2020. (3) Belize Diving will not issue any new stock or new long-term bonds....

  • Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of...

    Morrissey Technologies Inc.'s 2019 financial statements are shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2019 Cash $180,000 Accounts payable $360,000 360,000 Notes payable 56,000 Receivables Inventories 720,000 Accrued liabilities 180,000 Total current assets $1,260,000 Total current liabilities $596,000 Long-term debt 100,000 Fixed assets 1,440,000 Common stock 1,800,000 Retained earnings 204,000 $2,700,000 Total assets $2,700,000 Total liabilities and equity Morrissey Technologies Inc.: Income Statement for December 31, 2019 Sales $3,600,000 Operating costs including 3,279,720 depreciation EBIT $320,280...

  • 480 Part 5: Corporate Valuation and Governance Garlington Technologies Inc.'s 2010 financial statements are shown below:...

    480 Part 5: Corporate Valuation and Governance Garlington Technologies Inc.'s 2010 financial statements are shown below: Bolance Sheet os of December 31. 2010 (12-9) Addirional Funds Needed s 180,000 Accounts payable 360,000Notes payable Cash Receivables Inventories 1560 720,000 Accruals Total current liabilities S G Total current assets Fixed assets $1,260,000 1,800,0 1,440,000 Common stock Retained earnings 220 Total liabilities and equity Total assets Income Statement for December 31. 2010 S3,600,000 S 320,280 S 302,000 Sales Operating costs EBIT Interest EBT...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT