spreadsheet+from+class - 6,500,910 7,111,910 5,329,870...

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

View Full Document Right Arrow Icon
THE BUSINESS SCHOOL AT GEORGIA TECH Barry Marchman, Ph.D. Room 407 (404) 894-5110 Aguilera Acoustics Inc Year 0 1 2 3 4 5 Unit Sales 95,000 107,000 110,000 112,000 85,000 Price 330 330 330 330 330 Unit cost 210 210 210 210 210 Revenue 31,350,000 35,310,000 36,300,000 36,960,000 28,050,000 (Fixed Costs) (750,000) (750,000) (750,000) (750,000) (750,000) (Variable Costs) (19,950,000) (22,470,000) (23,100,000) (23,520,000) (17,850,000) Operating Profit 10,650,000 12,090,000 12,450,000 12,690,000 9,450,000 (Depreciation) (1,996,400) (3,428,600) (2,448,600) (1,748,600) (1,250,200) EBT 8,653,600 8,661,400 10,001,400 10,941,400 8,199,800 (Tax) (3,028,760) (3,031,490) (3,500,490) (3,829,490) (2,869,930) Net Income (NOPLAT) 5,624,840 5,629,910
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 6,500,910 7,111,910 5,329,870 Depreciation 1,996,400 3,428,600 2,448,600 1,748,600 1,250,200 Operating Cash Flow (OCF) 7,621,240 9,058,510 8,949,510 8,860,510 6,580,070 Capital (CAP) (14,000,000) 3,824,660 <-ATSV Net Working Capital (NWC) (1,500,000) (792,000) (198,000) (132,000) 1,782,000 840,000 Total Cash Flow (15,500,000) 6,829,240 8,860,510 8,817,510 10,642,510 11,244,730 Depreciation Rates 14.26% 24.49% 17.49% 12.49% 8.93% Book Values 12,003,600 8,575,000 6,126,400 4,377,800 3,127,600 salvage value 4,200,000 required return on project 30% tax rate 35% NPV 5,764,370 IRR 46.77% PI 1.37 MIRR 29.94% press ctrl and ~ together to see formulas...
View Full Document

This note was uploaded on 02/09/2012 for the course MGT 3078 taught by Professor Marchman during the Spring '12 term at Georgia Institute of Technology.

Ask a homework question - tutors are online