Question

1 Approved Answer

Posted on Jul 15, 2024

K19 $200,000 1 Forecastin 2 Grau Rate of Saler $100,000 $800,000 Neu Machinery 10.00 Proj 200+ Prej 2009 2006 $1,250.000 $12.500 Perei 2007 $175.000 $34.750

K19 $200,000 1 Forecastin 2 Grau Rate of Saler $100,000 $800,000 Neu Machinery 10.00 Proj 200+ Prej 2009 2006 $1,250.000 $12.500 Perei 2007 $175.000 $34.750 1440,000 $763,750 $591,250 $137,500 $55.000 $20.000 $328,250 5 6 Saler Laber Roumaterial COGS 10 Gr Profit 11 operating Cart 12 Other Fixecard 13 Depreciation 14 EBIT 15 interest 16 Taxable income 17 Taxer (40) 1 After Tax Inceme 19 Dividend(30%-ayat) 20 Contri Te RE 21 22 231cuh 24 AIR 25. Curr. Aure 3712.500 $537.500 $125.000 $55.000 $50.000 $307,500 525.000 $271,500 $92.500 $136.900 $416.70 $97,230 $249,946 $97571 $102,457 $175,000 $275,000 $255.000 $705,000 $192,500 $302,500 5280 500 $775,500 $1,550,000 28GFA 20 Ace Depr 20 INFA 21 Total Arrev $1.075.000 $1,750,000 $1,750,000 $545.000 $11.205,000 $1,980,500 $50,000 $75,000 $50,000 $55,000 $75,000 $55.000 $275,000 $215,000 34 AIP 35 HP 36 Accrual 37 Stortion of LTD 30 Our Lieb 39 40 LTD 10% 41s 42 RE 4 TL 44 ALFinancing Mecarer $600,000 $450,000 $425.000 $1,750,000 $0 $688,043 $410,000 5527457 $1,980,500 $9 Current Ratio Quick Ratio 24 2.7 17 50 51 Dette TIE 492% 4.0 49.1 1.9 55 I. TO TATO AIPTO AIRTO 2.8 0.1 12 4,5 2.0 9.7 14.3 4.5 ROL Red GwiPro Heri CPS S. 15.3% 111 4). $5.54 14.5% 19. 43.0 $5.95 35 Assume the following information is available about a company (on the last page and on D2L as an Excel file you can copy and use to look at the formulas). Build a forecasting model making the following the assumptions: Assumptions 10 years 1. The company must pay off $100,000 of LTD each year. 2. On the first day of 2007 they will install a new machine that $200,000 and will be depreciated SL over 3. On the first day of 2008 they will purchase a $100,000 machine to be depreciated over 10 years SL. 4. On the first day of 2009 they will purchase an $800,000 machine that will be depreciated over 10 years SL. 5. Assume stock can be sold for $25 a share and they initially have 25,000 shares outstanding. Assignment Copy the Excel Template which provides the spreadsheet given on the last page of the assignment to save having to make up your own spreadsheet. AutoSave H FC File Home Insert Draw Page Layout Formulas Data Review K19 fo A o F H 1 Pare-cuting NeuMehine 1200.. 110,000 10.000 2 Greuth Rate al Saler Pro 2003 Prei 2007 + Saler 11.275.000 320)750 Batterie COGS 10 Gran Predi Operating Cart 13 Other FixedCart 12 Depreciation 14 EBIT 10000 S18,500 1933,500 5125.000 $55,00 150 $207,500 115.000 $231,500 1920 $138.900 1417 391,230 STOSO 15710 327,500 555,000 170,000 $220 TS $94.04 $24. F5T 15146771 10. S102.457 16 Taxable.com 18 After Tax Incem 1 Dividend (20 pyet) O Centro 21 $192,500 $302,500 $115,00 $275.000 255.000 1705,000 1775,500 22 Carh 24 APR 25 in 25 Orrores 27 20 GA 29 Assum. Det 20. NFA 1 Total Arret $1,550,000 $475.000 $1,750,000 15.45.000 $1.205.000 51.420.500 51,700,000 22 $50,000 $75.000 $50.000 35 NIP Asarvel 37 ST portion of LTD **Ourr Liab $55.000 575.000 $55,000 $100.000 $285,000 $275.000 $600,000 $480,000 1425.000 $1,740,000 30 $1,000 1410,000 $927,457 $1,980,500 $0 22 1.6 2.7 1.7 40 LTD 410 42RE 43 TL & NW 44 Additional Financing Nederer 45 46 Botir 47 Current Ratio 43 Quick Ratio 49 50 51 DebRatio 52 TIE 52 54 Inw. To 55 TAT.O. 56 AIP 1.0 57 AIRTO 58 54 ROE Return on Soler 61 Grar Profit Martin 62 EPS Shacara 49.2% 4.0 49.1 3. 2. 0.7 14.3 4.5 2.8 0.7 14.3 4.5 15.) 11.1% 47.6% $5.55 > 14.5% 10.6% 43.0% $5.95 25.00 Sheet1 Sheet2 Sheet3 AutoSave H FC File Home Insert Draw Page Layout Formulas Data Review K19 fo A o F H 1 Pare-cuting NeuMehine 1200.. 110,000 10.000 2 Greuth Rate al Saler Pro 2003 Prei 2007 + Saler 11.275.000 320)750 Batterie COGS 10 Gran Predi Operating Cart 13 Other FixedCart 12 Depreciation 14 EBIT 10000 S18,500 1933,500 5125.000 $55,00 150 $207,500 115.000 $231,500 1920 $138.900 1417 391,230 STOSO 15710 327,500 555,000 170,000 $220 TS $94.04 $24. F5T 15146771 10. S102.457 16 Taxable.com 18 After Tax Incem 1 Dividend (20 pyet) O Centro 21 $192,500 $302,500 $115,00 $275.000 255.000 1705,000 1775,500 22 Carh 24 APR 25 in 25 Orrores 27 20 GA 29 Assum. Det 20. NFA 1 Total Arret $1,550,000 $475.000 $1,750,000 15.45.000 $1.205.000 51.420.500 51,700,000 22 $50,000 $75.000 $50.000 35 NIP Asarvel 37 ST portion of LTD **Ourr Liab $55.000 575.000 $55,000 $100.000 $285,000 $275.000 $600,000 $480,000 1425.000 $1,740,000 30 $1,000 1410,000 $927,457 $1,980,500 $0 22 1.6 2.7 1.7 40 LTD 410 42RE 43 TL & NW 44 Additional Financing Nederer 45 46 Botir 47 Current Ratio 43 Quick Ratio 49 50 51 DebRatio 52 TIE 52 54 Inw. To 55 TAT.O. 56 AIP 1.0 57 AIRTO 58 54 ROE Return on Soler 61 Grar Profit Martin 62 EPS Shacara 49.2% 4.0 49.1 3. 2. 0.7 14.3 4.5 2.8 0.7 14.3 4.5 15.) 11.1% 47.6% $5.55 > 14.5% 10.6% 43.0% $5.95 25.00 Sheet1 Sheet2 Sheet3 K19 $200,000 1 Forecastin 2 Grau Rate of Saler $100,000 $800,000 Neu Machinery 10.00 Proj 200+ Prej 2009 2006 $1,250.000 $12.500 Perei 2007 $175.000 $34.750 1440,000 $763,750 $591,250 $137,500 $55.000 $20.000 $328,250 5 6 Saler Laber Roumaterial COGS 10 Gr Profit 11 operating Cart 12 Other Fixecard 13 Depreciation 14 EBIT 15 interest 16 Taxable income 17 Taxer (40) 1 After Tax Inceme 19 Dividend(30%-ayat) 20 Contri Te RE 21 22 231cuh 24 AIR 25. Curr. Aure 3712.500 $537.500 $125.000 $55.000 $50.000 $307,500 525.000 $271,500 $92.500 $136.900 $416.70 $97,230 $249,946 $97571 $102,457 $175,000 $275,000 $255.000 $705,000 $192,500 $302,500 5280 500 $775,500 $1,550,000 28GFA 20 Ace Depr 20 INFA 21 Total Arrev $1.075.000 $1,750,000 $1,750,000 $545.000 $11.205,000 $1,980,500 $50,000 $75,000 $50,000 $55,000 $75,000 $55.000 $275,000 $215,000 34 AIP 35 HP 36 Accrual 37 Stortion of LTD 30 Our Lieb 39 40 LTD 10% 41s 42 RE 4 TL 44 ALFinancing Mecarer $600,000 $450,000 $425.000 $1,750,000 $0 $688,043 $410,000 5527457 $1,980,500 $9 Current Ratio Quick Ratio 24 2.7 17 50 51 Dette TIE 492% 4.0 49.1 1.9 55 I. TO TATO AIPTO AIRTO 2.8 0.1 12 4,5 2.0 9.7 14.3 4.5 ROL Red GwiPro Heri CPS S. 15.3% 111 4). $5.54 14.5% 19. 43.0 $5.95 35 Assume the following information is available about a company (on the last page and on D2L as an Excel file you can copy and use to look at the formulas). Build a forecasting model making the following the assumptions: Assumptions 10 years 1. The company must pay off $100,000 of LTD each year. 2. On the first day of 2007 they will install a new machine that $200,000 and will be depreciated SL over 3. On the first day of 2008 they will purchase a $100,000 machine to be depreciated over 10 years SL. 4. On the first day of 2009 they will purchase an $800,000 machine that will be depreciated over 10 years SL. 5. Assume stock can be sold for $25 a share and they initially have 25,000 shares outstanding. Assignment Copy the Excel Template which provides the spreadsheet given on the last page of the assignment to save having to make up your own spreadsheet. AutoSave H FC File Home Insert Draw Page Layout Formulas Data Review K19 fo A o F H 1 Pare-cuting NeuMehine 1200.. 110,000 10.000 2 Greuth Rate al Saler Pro 2003 Prei 2007 + Saler 11.275.000 320)750 Batterie COGS 10 Gran Predi Operating Cart 13 Other FixedCart 12 Depreciation 14 EBIT 10000 S18,500 1933,500 5125.000 $55,00 150 $207,500 115.000 $231,500 1920 $138.900 1417 391,230 STOSO 15710 327,500 555,000 170,000 $220 TS $94.04 $24. F5T 15146771 10. S102.457 16 Taxable.com 18 After Tax Incem 1 Dividend (20 pyet) O Centro 21 $192,500 $302,500 $115,00 $275.000 255.000 1705,000 1775,500 22 Carh 24 APR 25 in 25 Orrores 27 20 GA 29 Assum. Det 20. NFA 1 Total Arret $1,550,000 $475.000 $1,750,000 15.45.000 $1.205.000 51.420.500 51,700,000 22 $50,000 $75.000 $50.000 35 NIP Asarvel 37 ST portion of LTD **Ourr Liab $55.000 575.000 $55,000 $100.000 $285,000 $275.000 $600,000 $480,000 1425.000 $1,740,000 30 $1,000 1410,000 $927,457 $1,980,500 $0 22 1.6 2.7 1.7 40 LTD 410 42RE 43 TL & NW 44 Additional Financing Nederer 45 46 Botir 47 Current Ratio 43 Quick Ratio 49 50 51 DebRatio 52 TIE 52 54 Inw. To 55 TAT.O. 56 AIP 1.0 57 AIRTO 58 54 ROE Return on Soler 61 Grar Profit Martin 62 EPS Shacara 49.2% 4.0 49.1 3. 2. 0.7 14.3 4.5 2.8 0.7 14.3 4.5 15.) 11.1% 47.6% $5.55 > 14.5% 10.6% 43.0% $5.95 25.00 Sheet1 Sheet2 Sheet3 AutoSave H FC File Home Insert Draw Page Layout Formulas Data Review K19 fo A o F H 1 Pare-cuting NeuMehine 1200.. 110,000 10.000 2 Greuth Rate al Saler Pro 2003 Prei 2007 + Saler 11.275.000 320)750 Batterie COGS 10 Gran Predi Operating Cart 13 Other FixedCart 12 Depreciation 14 EBIT 10000 S18,500 1933,500 5125.000 $55,00 150 $207,500 115.000 $231,500 1920 $138.900 1417 391,230 STOSO 15710 327,500 555,000 170,000 $220 TS $94.04 $24. F5T 15146771 10. S102.457 16 Taxable.com 18 After Tax Incem 1 Dividend (20 pyet) O Centro 21 $192,500 $302,500 $115,00 $275.000 255.000 1705,000 1775,500 22 Carh 24 APR 25 in 25 Orrores 27 20 GA 29 Assum. Det 20. NFA 1 Total Arret $1,550,000 $475.000 $1,750,000 15.45.000 $1.205.000 51.420.500 51,700,000 22 $50,000 $75.000 $50.000 35 NIP Asarvel 37 ST portion of LTD **Ourr Liab $55.000 575.000 $55,000 $100.000 $285,000 $275.000 $600,000 $480,000 1425.000 $1,740,000 30 $1,000 1410,000 $927,457 $1,980,500 $0 22 1.6 2.7 1.7 40 LTD 410 42RE 43 TL & NW 44 Additional Financing Nederer 45 46 Botir 47 Current Ratio 43 Quick Ratio 49 50 51 DebRatio 52 TIE 52 54 Inw. To 55 TAT.O. 56 AIP 1.0 57 AIRTO 58 54 ROE Return on Soler 61 Grar Profit Martin 62 EPS Shacara 49.2% 4.0 49.1 3. 2. 0.7 14.3 4.5 2.8 0.7 14.3 4.5 15.) 11.1% 47.6% $5.55 > 14.5% 10.6% 43.0% $5.95 25.00 Sheet1 Sheet2 Sheet3