Forecasting HW

Forecasting HW - $1,850,000 Accum. Depr. $475,000 $575,000...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
02/23/2011 Justin Nomikos Forecasting Homework BUAD 341 1:00 pm Dr. Leinberger 08:42:46 Forecasting New Machinery $300,000 Growth Rate of Sales 15.00% Proj. 2007 2008 Sales $1,250,000 $1,437,500 Labor $312,500 $359,375 Raw material $400,000 $460,000 COGS $712,500 $819,375 Gross Profits $537,500 $618,125 Operating Costs $125,000 $143,750 Other Fixed Costs $55,000 $55,000 Depreciation $50,000 $100,000 EBIT $307,500 $319,375 Interest $76,000 $89,537 Taxable Income $231,500 $229,838 Taxes (40%) $92,600 $91,935 After Tax Income $138,900 $137,903 Dividends (30% payout) $41,670 $41,371 Contri. To RE $97,230 $96,532 Cash $175,000 $201,250 A/R $275,000 $316,250 Inv. $255,000 $293,250 Curr. Assets $705,000 $810,750 GFA $1,550,000
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $1,850,000 Accum. Depr. $475,000 $575,000 NFA $1,075,000 $1,275,000 Total Assets $1,780,000 $2,085,750 A/P $50,000 $57,500 N/P $75,000 $75,000 Accruals $50,000 $57,500 ST portion of LTD $100,000 $100,000 Curr. Liab. $275,000 $290,000 Add On Additional Financing Necessary $294,218 $284,333 LTD at 10% $600,000 $500,000 $9,553 CS $480,000 $480,000 $321 RE $425,000 $521,532 $11 TL & NW $1,780,000 $2,085,750 Additional Financing Necessary $0 $0 $294,218 A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44...
View Full Document

This document was uploaded on 02/22/2011.

Ask a homework question - tutors are online