Project 3 - Lab #1 - Shawshank Manufacturing

Project 3 - Lab #1 - Shawshank Manufacturing - 2,178,000...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Jecqueline DeRuyter 3-D Column Chart a0726519d3d1d94feed781c97d9321540965fbcf.xls 2004 2005 2006 2007 2008 2009 2010 (500,000) 0 500,000 1,000,000 1,500,000 2,000,000 2,500,000 Projected Net Income
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Shawshank Manufacturing a0726519d3d1d94feed781c97d9321540965fbcf.xls Shawshank Manufacturing Seven-Year Financial Projection 5/13/09 Total Net Revenue 265,807,211 266,712,616 267,621,106 268,532,691 269,447,380 270,365,185 271,286,117 Cost of Goods Sold 161,477,880 162,027,915 162,579,822 163,133,610 163,689,283 164,246,850 164,806,316 Gross Margin 104,329,330 104,684,702 105,041,284 105,399,081 105,758,097 106,118,335 106,479,801 Expenses Advertising 34,555,437 34,673,140 34,791,244 34,909,750 35,028,659 35,147,974 35,267,695 Maitenance 1,900,000 5,397,000 4,200,000 5,150,000 2,500,000 3,150,000 2,960,000 Rent 1,800,000 1,980,000
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 2,178,000 2,395,800 2,635,380 2,898,918 3,188,810 Salaries 58,477,586 58,676,776 58,876,643 59,077,192 59,278,424 59,480,341 59,682,946 Supplies 3,987,108 4,000,689 4,014,317 4,027,990 4,041,711 4,055,478 4,069,292 Total Expenses 100,720,132 104,727,605 104,060,204 105,560,732 103,484,174 104,732,711 105,168,742 Operating Income 3,609,198 (42,903) 981,080 (161,651) 2,273,923 1,385,625 1,311,058 Income Taxes 1,443,679 0 392,432 0 909,569 554,250 524,423 Net Income 2,165,519 (42,903) 588,648 (161,651) 1,364,354 831,375 786,635 Assumptions Units Sold in Year 2003 12,459,713 Unit Cost $12.96 Annual Sales Growth 4.25% Annual Price Decrease 3.75% Margin 39.25% 2004 2005 2006 2007 2008 2009 2010...
View Full Document

Page1 / 2

Project 3 - Lab #1 - Shawshank Manufacturing - 2,178,000...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online