Excel Project HW

Excel Project HW - $566.03 $11,868.66 $274,480.63 12...

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

View Full Document Right Arrow Icon
Name Michael Hinde Section 10 Date 11/30/2011 “Apps are US” Projected Costs Price Total Cost 7 Computers $1,950.00 $13,650.00 Total Exp $482,061.00 6 iPads $459.00 $2,754.00 % Down 10% 3 iPhones $219.00 $657.00 Loan Amt $433,854.90 5 developers $72,000.00 $360,000.00 Int Rate 4% 1 Proj Leader $105,000.00 $105,000.00 term 2 Total Expences $482,061.00 Total Project Cost Payment Number Monthly Payment Balance 0 $433,854.90 1 $18,840.12 $1,446.18 $17,393.93 $416,460.97 2 $18,084.79 $1,332.55 $16,752.24 $399,708.73 3 $17,357.32 $1,225.35 $16,131.97 $383,576.76 4 $16,656.79 $1,124.29 $15,532.50 $368,044.26 5 $15,982.29 $1,029.09 $14,953.20 $353,091.06 6 $15,332.95 $939.46 $14,393.49 $338,697.57 7 $14,707.92 $855.14 $13,852.78 $324,844.79 8 $14,106.36 $775.88 $13,330.48 $311,514.31 9 $13,527.48 $701.43 $12,826.06 $298,688.25 10 $12,970.51 $631.55 $12,338.96 $286,349.29 11 $12,434.70
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $566.03 $11,868.66 $274,480.63 12 $11,919.30 $504.65 $11,414.65 $263,065.98 13 $11,423.62 $447.20 $10,976.42 $252,089.55 14 $10,946.97 $393.48 $10,553.49 $241,536.06 15 $10,488.68 $343.30 $10,145.39 $231,390.67 16 $10,048.12 $296.48 $9,751.64 $221,639.03 17 $9,624.66 $252.85 $9,371.81 $212,267.22 18 $9,217.69 $212.24 $9,005.45 $203,261.78 19 $8,826.63 $174.49 $8,652.14 $194,609.64 20 $8,450.91 $139.45 $8,311.46 $186,298.18 21 $8,089.98 $106.97 $7,983.01 $178,315.17 22 $7,743.32 $76.92 $7,666.40 $170,648.77 23 $7,410.41 $49.16 $7,361.25 $163,287.52 24 $7,090.75 $23.56 $7,067.19 $156,220.33 Totals Monthly Interest Payment Monthly Principle Payment A B C D E F 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

Ask a homework question - tutors are online