Studio Recording Equipment Amortization Input Area Equipment Cost Down Payment Amount of the Loan Loan APR # of Years in Loan # of Payments Per Year Monthly Payment
$ 25,000.00 $ 5,000.00 $ 20,000.00 6% 5 12 $ 386.66
Pmt # 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
Beginning Balance $ 20,000.00 $ 19,713.34 $ 19,425.25 $ 19,135.72 $ 18,844.75 $ 18,552.32 $ 18,258.42 $ 17,963.06 $ 17,666.22 $ 17,367.89 $ 17,068.07 $ 16,766.76 $ 16,463.94 $ 16,159.60 $ 15,853.74 $ 15,546.35 $ 15,237.43 $ 14,926.96 $ 14,614.94 $ 14,301.36 $ 13,986.21 $ 13,669.49 $ 13,351.18 $ 13,031.28 $ 12,709.78 $ 12,386.67 $ 12,061.95 $ 11,735.60 $ 11,407.62 $ 11,078.00 $ 10,746.74 $ 10,413.82 $ 10,079.23
Student Name
Monthly Payment $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66
Interest Paid $ 100.00 $ 98.57 $ 97.13 $ 95.68 $ 94.22 $ 92.76 $ 91.29 $ 89.82 $ 88.33 $ 86.84 $ 85.34 $ 83.83 $ 82.32 $ 80.80 $ 79.27 $ 77.73 $ 76.19 $ 74.63 $ 73.07 $ 71.51 $ 69.93 $ 68.35 $ 66.76 $ 65.16 $ 63.55 $ 61.93 $ 60.31 $ 58.68 $ 57.04 $ 55.39 $ 53.73 $ 52.07 $ 50.40 Loan
Principal Reduction $ 286.66 $ 288.09 $ 289.53 $ 290.98 $ 292.43 $ 293.89 $ 295.36 $ 296.84 $ 298.32 $ 299.82 $ 301.32 $ 302.82 $ 304.34 $ 305.86 $ 307.39 $ 308.92 $ 310.47 $ 312.02 $ 313.58 $ 315.15 $ 316.72 $ 318.31 $ 319.90 $ 321.50 $ 323.11 $ 324.72 $ 326.35 $ 327.98 $ 329.62 $ 331.27 $ 332.92 $ 334.59 $ 336.26
Cumulative Yearly Interest
Ending Balance $ 19,713.34 $ 19,425.25 $ 19,135.72 $ 18,844.75 $ 18,552.32 $ 18,258.42 $ 17,963.06 $ 17,666.22 $ 17,367.89 $ 17,068.07 $ 16,766.76 $ 16,463.94 $ 1,103.81 $ 16,159.60 $ 15,853.74 $ 15,546.35 $ 15,237.43 $ 14,926.96 $ 14,614.94 $ 14,301.36 $ 13,986.21 $ 13,669.49 $ 13,351.18 $ 13,031.28 $ 12,709.78 $ 885.71 $ 12,386.67 $ 12,061.95 $ 11,735.60 $ 11,407.62 $ 11,078.00 $ 10,746.74 $ 10,413.82 $ 10,079.23 $ 9,742.97 e07b1studio_LastnameFirstname.xlsx
Pmt # 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 Totals
Student Name
Beginning Balance $ 9,742.97 $ 9,405.03 $ 9,065.40 $ 8,724.07 $ 8,381.03 $ 8,036.28 $ 7,689.81 $ 7,341.60 $ 6,991.65 $ 6,639.95 $ 6,286.50 $ 5,931.27 $ 5,574.27 $ 5,215.49 $ 4,854.91 $ 4,492.53 $ 4,128.34 $ 3,762.32 $ 3,394.48 $ 3,024.79 $ 2,653.26 $ 2,279.87 $ 1,904.62 $ 1,527.48 $ 1,148.46 $ 767.55 $ 384.73
Monthly Payment $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66 $ 386.66
Principal Reduction $ 337.94 $ 339.63 $ 341.33 $ 343.04 $ 344.75 $ 346.47 $ 348.21 $ 349.95 $ 351.70 $ 353.46 $ 355.22 $ 357.00 $ 358.78 $ 360.58 $ 362.38 $ 364.19 $ 366.01 $ 367.84 $ 369.68 $ 371.53 $ 373.39 $ 375.26 $ 377.13 $ 379.02 $ 380.91 $ 382.82 $ 384.73
Cumulative Ending Balance Yearly Interest $ 9,405.03 $ 9,065.40 $ 8,724.07 $ 654.16 $ 8,381.03 $ 8,036.28 $ 7,689.81 $ 7,341.60 $ 6,991.65 $ 6,639.95 $ 6,286.50 $ 5,931.27 $ 5,574.27 $ 5,215.49 $ 4,854.91 $ 4,492.53 $ 408.33 $ 4,128.34 $ 3,762.32 $ 3,394.48 $ 3,024.79 $ 2,653.26 $ 2,279.87 $ 1,904.62 $ 1,527.48 $ 1,148.46 $ 767.55 $ 384.73 $ 0.00 $ 147.34
$ 23,199.36 $ 3,199.36 $ 20,000.00
$ 3,199.36
Interest Paid $ 48.71 $ 47.03 $ 45.33 $ 43.62 $ 41.91 $ 40.18 $ 38.45 $ 36.71 $ 34.96 $ 33.20 $ 31.43 $ 29.66 $ 27.87 $ 26.08 $ 24.27 $ 22.46 $ 20.64 $ 18.81 $ 16.97 $ 15.12 $ 13.27 $ 11.40 $ 9.52 $ 7.64 $ 5.74 $ 3.84 $ 1.92
Loan
e07b1studio_LastnameFirstname.xlsx
Studio Recording Equipment Analysis Input Area Discount Rate: No. of Useful Years: Upfront Cost (Year 0): Yearly Net Income: Yearly Recurring Costs:
8% 5 $ 25,000 $ 50,000 $ 20,000
Year 0 Net Income Upfront Cost Recurring Costs Net Yearly Benefit
Student Name
Year 1 Year 2 Year 3 Year 4 Year 5 $ 50,000 $ 50,000 $ 50,000 $ 50,000 $ 50,000
$ 25,000 20,000 20,000
20,000
20,000
Present Value $199,635.50 25,000.00 20,000 (79,854.20)
NPV Check
$ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 30,000 $ 144,781.30 $ 144,781.30
PV and NPV
e07b1studio_LastnameFirstname.xlsx
