FIN 691 Graded Valuation Problem Set

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

691-Q2135

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by CorporalPrairieDog2336

CALCULATING FUTURE VALUE OF A LUMP SUM AND PERIODIC INVEST You invest $750 today in an account that pays 8% per year. What is your account worth in 1 Initial investment $ 750.00 Interest rate 8% Number of years 10 Future account balance $ 1,619.19 Year Future Value (FV) 1 $ 810.00 2 $ 874.80 3 $ 944.78 4 $ 1,020.37 5 $ 1,102.00 6 $ 1,190.16 7 $ 1,285.37 8 $ 1,388.20 9 $ 1,499.25 10 $ 1,619.19 11 $ 1,748.73 12 $ 1,888.63 13 $ 2,039.72 14 $ 2,202.90 15 $ 2,379.13 Additional yearly investments $ 500.00 FV with additional investments $2,401.47 You also have the option to withdraw it early or leave your investment in the account for up FV of the account at the end of each year? If you invested an extra $50 to the account at the beginning of each year what would the fu years? 0 $- $500.00 $1,000.00 $1,500.00 $2,000.00 $2,500.00 Future Value

TMENTS 10 years? p to 15 years. What is the uture value be after 10 2 4 6 8 10 12 14 16 Future Value (FV) Future Value (FV) Year

TWO-WAY DATA TABLE: DISCOUNT RATE VS. Annual investment $ 5,500.00 Interest rate 7.5% Number of years 12 FV function $108,930.29 $108,930.29 3250 3500 3750 4000 4250 0% 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% 13% 14% 15% You intend to retire in 12 years and therefore plan to make 12 annual deposits of $5,500 (the current and each succeeding deposit made at the end of years 1, 2, . . . ,14. The assumed interest rate is 7.5% "FV" function. Wanting to see what the result would be if you contributed less than your maximum amount, or rece out to compute the range of possibilities. Create a two-way table to calculate the resulting FVs for bo annual investment amounts.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ANNUAL INVESTMENT 4500 4750 5000 5250 5500 t IRA max for those under age 55), with the first deposit made in T 0 (today) % What is the future value of all these deposits at the end of year 12? Use the eived an interest rate higher or lower than your original assumption, you set oth the range of possible interest rates, 0% to 15%, and the range of possible

CALCULATING PRESENT AND FUTURE VALUE OF AN ANNUITY INVESTMENT Interest rate 7% Year Cash flow at end of year Present Value of cash flow 4 $ 5,000.00 $ 3,814.48 5 $ 5,000.00 $ 3,564.93 6 $ 5,000.00 $ 3,331.71 7 $ 10,000.00 $ 6,227.50 Present value of all cash flows $ 16,938.62 Investment term (years) 7 PV of investment cost $6,227.50 FV of investment cost $10,000.00 PV of all investment cash flows $10,548.52 FV of investment cash flows $16,938.62 Difference in future value $6,390.10 You have the opportunity to invest a portion of your hard earned savings into a new investment. This i pay nothing for the first 3 years, $5,000 each for years 4–6, and a final payment of $10,000 in year 7. T interest rate of 7%. What is the PV for the cash flow of each year something is received (years 4–7)? If this investment only cost you $10,000, what is the difference in the future value of making the inves Solve for the FV using the PV of the $10,000 cost of the investment and the PV of all of the future cash 0 in payments for each.)

investment is likely to There is an assumed stment versus not? h flows. (Hint: Assume

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

CALCULATING PERIODIC INTEREST RATE Present Value $ 10,000.00 Quarterly payment $ 395.00 Number of years 8 Number of quarters 32 Quarterly interest rate 1.49% Annual interest rate (APR) 17.84% Effective annual interest rate (EAR) 19.38% You have just taken out a loan for a PV of $10,000. The term is 8 years, with a quarterly payment of $395. Calculate the quarterly interest rate using the "RATE" function. However, most interest rates are quoted as "Annual Percentage Rates" or APR. What is the APR? Using the "EFFECT" function, what is the "Effective annual interest rate" EAR?

CALCULATING CAR LOANS AND PAYMENTS Monthly payment $ 200.00 Interest rate 4.00% Monthly interst rate 0.33% Number of years 6 Number of months 72 PV function $12,783.49 200.000000000005 Months paid 12 Remaining number of months 60 Balance remaining $13,574.77 New monthly payment $ 250.00 Months remaining 60.00 How many months of payments do you avoid by increasing the payment made after the first year? Months of payments saved 0.00 You are shopping for a new car and have a budgeted monthly payment of $200. You are being offered an APR interest rate of 4.00% on a 6-year loan. What is the maximum loan you can afford for your car? After making one year's worth of payments, you received a promotion at your job and can now afford to add an extra $50 a month to your monthly payment in hopes of paying off the car before the end of the 6-year loan. What is the remaining balance of the loan? What is your new monthly payment you will make? With these larger payments, how much time is left on the loan, using "NPER"?

CREATING AN AMORTIZATION TABLE Loan Table Interest Rate 4.50% Monthly Interest Rate 0.38% Number of Periods 120 Principal $ 140,000.00 Payment $1,450.94 Month Balance at Start of Period Monthly Payment Interest 1 $ 140,000.00 $1,450.94 $ 525.00 2 $ 139,074.06 $1,450.94 $ 521.53 3 $ 138,144.65 $1,450.94 $ 518.04 4 $ 137,211.76 $1,450.94 $ 514.54 5 $ 136,275.36 $1,450.94 $ 511.03 6 $ 135,335.46 $1,450.94 $ 507.51 7 $ 134,392.03 $1,450.94 $ 503.97 8 $ 133,445.06 $1,450.94 $ 500.42 9 $ 132,494.54 $1,450.94 $ 496.85 10 $ 131,540.45 $1,450.94 $ 493.28 11 $ 130,582.79 $1,450.94 $ 489.69 12 $ 129,621.53 $1,450.94 $ 486.08 13 $ 128,656.67 $1,450.94 $ 482.46 14 $ 127,688.20 $1,450.94 $ 478.83 15 $ 126,716.09 $1,450.94 $ 475.19 16 $ 125,740.33 $1,450.94 $ 471.53 17 $ 124,760.92 $1,450.94 $ 467.85 18 $ 123,777.83 $1,450.94 $ 464.17 19 $ 122,791.06 $1,450.94 $ 460.47 20 $ 121,800.58 $1,450.94 $ 456.75 21 $ 120,806.40 $1,450.94 $ 453.02 22 $ 119,808.48 $1,450.94 $ 449.28 23 $ 118,806.82 $1,450.94 $ 445.53 24 $ 117,801.41 $1,450.94 $ 441.76 25 $ 116,792.22 $1,450.94 $ 437.97 26 $ 115,779.25 $1,450.94 $ 434.17 27 $ 114,762.49 $1,450.94 $ 430.36 28 $ 113,741.91 $1,450.94 $ 426.53 29 $ 112,717.50 $1,450.94 $ 422.69 30 $ 111,689.25 $1,450.94 $ 418.83 You have just taken out a mortgage for a PV of $140,000. The term is 10 years with an APR of 4.5%. Calcula "PMT" function. You are interested in seeing how much of each monthly payment is applied to interest and principal each m balance. Complete the resulting amortization table to calculate the data.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

31 $ 110,657.14 $1,450.94 $ 414.96 32 $ 109,621.17 $1,450.94 $ 411.08 33 $ 108,581.31 $1,450.94 $ 407.18 34 $ 107,537.55 $1,450.94 $ 403.27 35 $ 106,489.87 $1,450.94 $ 399.34 36 $ 105,438.27 $1,450.94 $ 395.39 37 $ 104,382.72 $1,450.94 $ 391.44 38 $ 103,323.22 $1,450.94 $ 387.46 39 $ 102,259.74 $1,450.94 $ 383.47 40 $ 101,192.27 $1,450.94 $ 379.47 41 $ 100,120.81 $1,450.94 $ 375.45 42 $ 99,045.32 $1,450.94 $ 371.42 43 $ 97,965.80 $1,450.94 $ 367.37 44 $ 96,882.23 $1,450.94 $ 363.31 45 $ 95,794.60 $1,450.94 $ 359.23 46 $ 94,702.89 $1,450.94 $ 355.14 47 $ 93,607.08 $1,450.94 $ 351.03 48 $ 92,507.17 $1,450.94 $ 346.90 49 $ 91,403.13 $1,450.94 $ 342.76 50 $ 90,294.95 $1,450.94 $ 338.61 51 $ 89,182.62 $1,450.94 $ 334.43 52 $ 88,066.11 $1,450.94 $ 330.25 53 $ 86,945.42 $1,450.94 $ 326.05 54 $ 85,820.53 $1,450.94 $ 321.83 55 $ 84,691.42 $1,450.94 $ 317.59 56 $ 83,558.07 $1,450.94 $ 313.34 57 $ 82,420.47 $1,450.94 $ 309.08 58 $ 81,278.61 $1,450.94 $ 304.79 59 $ 80,132.46 $1,450.94 $ 300.50 60 $ 78,982.02 $1,450.94 $ 296.18 61 $ 77,827.26 $1,450.94 $ 291.85 62 $ 76,668.17 $1,450.94 $ 287.51 63 $ 75,504.74 $1,450.94 $ 283.14 64 $ 74,336.94 $1,450.94 $ 278.76 65 $ 73,164.77 $1,450.94 $ 274.37 66 $ 71,988.19 $1,450.94 $ 269.96 67 $ 70,807.21 $1,450.94 $ 265.53 68 $ 69,621.80 $1,450.94 $ 261.08 69 $ 68,431.94 $1,450.94 $ 256.62 70 $ 67,237.62 $1,450.94 $ 252.14 71 $ 66,038.82 $1,450.94 $ 247.65 72 $ 64,835.52 $1,450.94 $ 243.13 73 $ 63,627.72 $1,450.94 $ 238.60 74 $ 62,415.38 $1,450.94 $ 234.06 75 $ 61,198.50 $1,450.94 $ 229.49

76 $ 59,977.05 $1,450.94 $ 224.91 77 $ 58,751.03 $1,450.94 $ 220.32 78 $ 57,520.40 $1,450.94 $ 215.70 79 $ 56,285.17 $1,450.94 $ 211.07 80 $ 55,045.29 $1,450.94 $ 206.42 81 $ 53,800.77 $1,450.94 $ 201.75 82 $ 52,551.59 $1,450.94 $ 197.07 83 $ 51,297.72 $1,450.94 $ 192.37 84 $ 50,039.14 $1,450.94 $ 187.65 85 $ 48,775.85 $1,450.94 $ 182.91 86 $ 47,507.82 $1,450.94 $ 178.15 87 $ 46,235.03 $1,450.94 $ 173.38 88 $ 44,957.47 $1,450.94 $ 168.59 89 $ 43,675.13 $1,450.94 $ 163.78 90 $ 42,387.97 $1,450.94 $ 158.95 91 $ 41,095.98 $1,450.94 $ 154.11 92 $ 39,799.15 $1,450.94 $ 149.25 93 $ 38,497.46 $1,450.94 $ 144.37 94 $ 37,190.88 $1,450.94 $ 139.47 95 $ 35,879.41 $1,450.94 $ 134.55 96 $ 34,563.02 $1,450.94 $ 129.61 97 $ 33,241.69 $1,450.94 $ 124.66 98 $ 31,915.41 $1,450.94 $ 119.68 99 $ 30,584.15 $1,450.94 $ 114.69 100 $ 29,247.90 $1,450.94 $ 109.68 101 $ 27,906.64 $1,450.94 $ 104.65 102 $ 26,560.35 $1,450.94 $ 99.60 103 $ 25,209.01 $1,450.94 $ 94.53 104 $ 23,852.60 $1,450.94 $ 89.45 105 $ 22,491.11 $1,450.94 $ 84.34 106 $ 21,124.51 $1,450.94 $ 79.22 107 $ 19,752.79 $1,450.94 $ 74.07 108 $ 18,375.92 $1,450.94 $ 68.91 109 $ 16,993.89 $1,450.94 $ 63.73 110 $ 15,606.68 $1,450.94 $ 58.53 111 $ 14,214.26 $1,450.94 $ 53.30 112 $ 12,816.63 $1,450.94 $ 48.06 113 $ 11,413.75 $1,450.94 $ 42.80 114 $ 10,005.61 $1,450.94 $ 37.52 115 $ 8,592.19 $1,450.94 $ 32.22 116 $ 7,173.47 $1,450.94 $ 26.90 117 $ 5,749.43 $1,450.94 $ 21.56 118 $ 4,320.05 $1,450.94 $ 16.20 119 $ 2,885.31 $1,450.94 $ 10.82 120 $ 1,445.19 $1,450.94 $ 5.42

Month of final payment 100 Month Balance at Start of Period Monthly Payment Additional Payments 1 $ 140,000.00 $1,450.94 50 2 $ 139,024.06 $1,450.94 50 3 $ 138,044.46 $1,450.94 50 4 $ 137,061.19 $1,450.94 50 5 $ 136,074.23 $1,450.94 50 6 $ 135,083.56 $1,450.94 50 7 $ 134,089.19 $1,450.94 50 8 $ 133,091.08 $1,450.94 50 9 $ 132,089.23 $1,450.94 50 10 $ 131,083.63 $1,450.94 50 11 $ 130,074.25 $1,450.94 50 12 $ 129,061.09 $1,450.94 50 13 $ 128,044.13 $1,450.94 100 14 $ 126,973.36 $1,450.94 100 15 $ 125,898.57 $1,450.94 100 16 $ 124,819.75 $1,450.94 100 17 $ 123,736.88 $1,450.94 100 18 $ 122,649.95 $1,450.94 100 19 $ 121,558.95 $1,450.94 100 20 $ 120,463.86 $1,450.94 100 21 $ 119,364.66 $1,450.94 100 22 $ 118,261.33 $1,450.94 100 23 $ 117,153.87 $1,450.94 100 24 $ 116,042.26 $1,450.94 100 25 $ 114,926.48 $1,450.94 150 26 $ 113,756.51 $1,450.94 150 27 $ 112,582.16 $1,450.94 150 28 $ 111,403.40 $1,450.94 150 29 $ 110,220.23 $1,450.94 150 30 $ 109,032.61 $1,450.94 150 31 $ 107,840.54 $1,450.94 150 32 $ 106,644.01 $1,450.94 150 33 $ 105,442.98 $1,450.94 150 34 $ 104,237.45 $1,450.94 150 35 $ 103,027.40 $1,450.94 150 36 $ 101,812.81 $1,450.94 150 You figure that you will be able to pay more than the minimum each month, with the extra payment being principal. For the first 12 months, you plan to pay an extra $50, and increasing that by $50 every 12 month 24, $150 addtional in months 25–36, etc.). Complete the amortization table, taking into account the addtio month will you make your final payment?

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

37 $ 100,593.67 $1,450.94 200 38 $ 99,319.96 $1,450.94 200 39 $ 98,041.47 $1,450.94 200 40 $ 96,758.18 $1,450.94 200 41 $ 95,470.09 $1,450.94 200 42 $ 94,177.16 $1,450.94 200 43 $ 92,879.38 $1,450.94 200 44 $ 91,576.74 $1,450.94 200 45 $ 90,269.22 $1,450.94 200 46 $ 88,956.78 $1,450.94 200 47 $ 87,639.43 $1,450.94 200 48 $ 86,317.14 $1,450.94 200 49 $ 84,989.89 $1,450.94 250 50 $ 83,607.66 $1,450.94 250 51 $ 82,220.25 $1,450.94 250 52 $ 80,827.64 $1,450.94 250 53 $ 79,429.80 $1,450.94 250 54 $ 78,026.72 $1,450.94 250 55 $ 76,618.38 $1,450.94 250 56 $ 75,204.76 $1,450.94 250 57 $ 73,785.84 $1,450.94 250 58 $ 72,361.60 $1,450.94 250 59 $ 70,932.01 $1,450.94 250 60 $ 69,497.07 $1,450.94 250 61 $ 68,056.74 $1,450.94 300 62 $ 66,561.01 $1,450.94 300 63 $ 65,059.68 $1,450.94 300 64 $ 63,552.71 $1,450.94 300 65 $ 62,040.09 $1,450.94 300 66 $ 60,521.80 $1,450.94 300 67 $ 58,997.82 $1,450.94 300 68 $ 57,468.12 $1,450.94 300 69 $ 55,932.69 $1,450.94 300 70 $ 54,391.50 $1,450.94 300 71 $ 52,844.52 $1,450.94 300 72 $ 51,291.75 $1,450.94 300 73 $ 49,733.16 $1,450.94 350 74 $ 48,118.71 $1,450.94 350 75 $ 46,498.22 $1,450.94 350 76 $ 44,871.65 $1,450.94 350 77 $ 43,238.98 $1,450.94 350 78 $ 41,600.18 $1,450.94 350 79 $ 39,955.24 $1,450.94 350 80 $ 38,304.14 $1,450.94 350 81 $ 36,646.84 $1,450.94 350

82 $ 34,983.32 $1,450.94 350 83 $ 33,313.57 $1,450.94 350 84 $ 31,637.56 $1,450.94 350 85 $ 29,955.26 $1,450.94 400 86 $ 28,216.65 $1,450.94 400 87 $ 26,471.52 $1,450.94 400 88 $ 24,719.85 $1,450.94 400 89 $ 22,961.61 $1,450.94 400 90 $ 21,196.77 $1,450.94 400 91 $ 19,425.32 $1,450.94 400 92 $ 17,647.23 $1,450.94 400 93 $ 15,862.46 $1,450.94 400 94 $ 14,071.01 $1,450.94 400 95 $ 12,272.83 $1,450.94 400 96 $ 10,467.92 $1,450.94 400 97 $ 8,656.23 $1,450.94 450 98 $ 6,787.75 $1,450.94 450 99 $ 4,912.27 $1,450.94 450 100 $ 3,029.75 $1,450.94 450 101 $ 1,140.17 $1,450.94 450 102 $ (756.49) $1,450.94 450 103 $ (2,660.27) $1,450.94 450 104 $ (4,571.19) $1,450.94 450 105 $ (6,489.27) $1,450.94 450 106 $ (8,414.54) $1,450.94 450 107 $ (10,347.04) $1,450.94 450 108 $ (12,286.78) $1,450.94 450 109 110 111 112 113 114 115 116 117 118 119 120

Principal Reduction Ending Balance $925.94 $ 139,074.06 $929.41 $ 138,144.65 $932.90 $ 137,211.76 $936.39 $ 136,275.36 $939.91 $ 135,335.46 $943.43 $ 134,392.03 $946.97 $ 133,445.06 $950.52 $ 132,494.54 $954.09 $ 131,540.45 $957.66 $ 130,582.79 $961.25 $ 129,621.53 $964.86 $ 128,656.67 $968.48 $ 127,688.20 $972.11 $ 126,716.09 $975.75 $ 125,740.33 $979.41 $ 124,760.92 $983.09 $ 123,777.83 $986.77 $ 122,791.06 $990.47 $ 121,800.58 $994.19 $ 120,806.40 $997.92 $ 119,808.48 $1,001.66 $ 118,806.82 $1,005.41 $ 117,801.41 $1,009.18 $ 116,792.22 $1,012.97 $ 115,779.25 $1,016.77 $ 114,762.49 $1,020.58 $ 113,741.91 $1,024.41 $ 112,717.50 $1,028.25 $ 111,689.25 $1,032.11 $ 110,657.14 ate the monthly payments due using the month, as well as the resulting ending

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

$1,035.98 $ 109,621.17 $1,039.86 $ 108,581.31 $1,043.76 $ 107,537.55 $1,047.67 $ 106,489.87 $1,051.60 $ 105,438.27 $1,055.55 $ 104,382.72 $1,059.50 $ 103,323.22 $1,063.48 $ 102,259.74 $1,067.47 $ 101,192.27 $1,071.47 $ 100,120.81 $1,075.49 $ 99,045.32 $1,079.52 $ 97,965.80 $1,083.57 $ 96,882.23 $1,087.63 $ 95,794.60 $1,091.71 $ 94,702.89 $1,095.80 $ 93,607.08 $1,099.91 $ 92,507.17 $1,104.04 $ 91,403.13 $1,108.18 $ 90,294.95 $1,112.33 $ 89,182.62 $1,116.51 $ 88,066.11 $1,120.69 $ 86,945.42 $1,124.89 $ 85,820.53 $1,129.11 $ 84,691.42 $1,133.35 $ 83,558.07 $1,137.60 $ 82,420.47 $1,141.86 $ 81,278.61 $1,146.15 $ 80,132.46 $1,150.44 $ 78,982.02 $1,154.76 $ 77,827.26 $1,159.09 $ 76,668.17 $1,163.43 $ 75,504.74 $1,167.80 $ 74,336.94 $1,172.18 $ 73,164.77 $1,176.57 $ 71,988.19 $1,180.98 $ 70,807.21 $1,185.41 $ 69,621.80 $1,189.86 $ 68,431.94 $1,194.32 $ 67,237.62 $1,198.80 $ 66,038.82 $1,203.29 $ 64,835.52 $1,207.81 $ 63,627.72 $1,212.34 $ 62,415.38 $1,216.88 $ 61,198.50 $1,221.45 $ 59,977.05

$1,226.03 $ 58,751.03 $1,230.62 $ 57,520.40 $1,235.24 $ 56,285.17 $1,239.87 $ 55,045.29 $1,244.52 $ 53,800.77 $1,249.19 $ 52,551.59 $1,253.87 $ 51,297.72 $1,258.57 $ 50,039.14 $1,263.29 $ 48,775.85 $1,268.03 $ 47,507.82 $1,272.79 $ 46,235.03 $1,277.56 $ 44,957.47 $1,282.35 $ 43,675.13 $1,287.16 $ 42,387.97 $1,291.99 $ 41,095.98 $1,296.83 $ 39,799.15 $1,301.69 $ 38,497.46 $1,306.57 $ 37,190.88 $1,311.47 $ 35,879.41 $1,316.39 $ 34,563.02 $1,321.33 $ 33,241.69 $1,326.28 $ 31,915.41 $1,331.26 $ 30,584.15 $1,336.25 $ 29,247.90 $1,341.26 $ 27,906.64 $1,346.29 $ 26,560.35 $1,351.34 $ 25,209.01 $1,356.41 $ 23,852.60 $1,361.49 $ 22,491.11 $1,366.60 $ 21,124.51 $1,371.72 $ 19,752.79 $1,376.87 $ 18,375.92 $1,382.03 $ 16,993.89 $1,387.21 $ 15,606.68 $1,392.41 $ 14,214.26 $1,397.64 $ 12,816.63 $1,402.88 $ 11,413.75 $1,408.14 $ 10,005.61 $1,413.42 $ 8,592.19 $1,418.72 $ 7,173.47 $1,424.04 $ 5,749.43 $1,429.38 $ 4,320.05 $1,434.74 $ 2,885.31 $1,440.12 $ 1,445.19 $1,445.52 $ (0.33)

Interest Principal Reduction Ending Balance $ 525.00 $975.94 $ 139,024.06 $ 521.34 $979.60 $ 138,044.46 $ 517.67 $983.27 $ 137,061.19 $ 513.98 $986.96 $ 136,074.23 $ 510.28 $990.66 $ 135,083.56 $ 506.56 $994.38 $ 134,089.19 $ 502.83 $998.11 $ 133,091.08 $ 499.09 $1,001.85 $ 132,089.23 $ 495.33 $1,005.61 $ 131,083.63 $ 491.56 $1,009.38 $ 130,074.25 $ 487.78 $1,013.16 $ 129,061.09 $ 483.98 $1,016.96 $ 128,044.13 $ 480.17 $1,070.77 $ 126,973.36 $ 476.15 $1,074.79 $ 125,898.57 $ 472.12 $1,078.82 $ 124,819.75 $ 468.07 $1,082.87 $ 123,736.88 $ 464.01 $1,086.93 $ 122,649.95 $ 459.94 $1,091.00 $ 121,558.95 $ 455.85 $1,095.09 $ 120,463.86 $ 451.74 $1,099.20 $ 119,364.66 $ 447.62 $1,103.32 $ 118,261.33 $ 443.48 $1,107.46 $ 117,153.87 $ 439.33 $1,111.61 $ 116,042.26 $ 435.16 $1,115.78 $ 114,926.48 $ 430.97 $1,169.97 $ 113,756.51 $ 426.59 $1,174.35 $ 112,582.16 $ 422.18 $1,178.76 $ 111,403.40 $ 417.76 $1,183.18 $ 110,220.23 $ 413.33 $1,187.61 $ 109,032.61 $ 408.87 $1,192.07 $ 107,840.54 $ 404.40 $1,196.54 $ 106,644.01 $ 399.92 $1,201.02 $ 105,442.98 $ 395.41 $1,205.53 $ 104,237.45 $ 390.89 $1,210.05 $ 103,027.40 $ 386.35 $1,214.59 $ 101,812.81 $ 381.80 $1,219.14 $ 100,593.67 allocated directly to decreasing the hs thereafter ($100 additional in months 13– onal mothly principal payments. In which

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

$ 377.23 $1,273.71 $ 99,319.96 $ 372.45 $1,278.49 $ 98,041.47 $ 367.66 $1,283.28 $ 96,758.18 $ 362.84 $1,288.10 $ 95,470.09 $ 358.01 $1,292.93 $ 94,177.16 $ 353.16 $1,297.78 $ 92,879.38 $ 348.30 $1,302.64 $ 91,576.74 $ 343.41 $1,307.53 $ 90,269.22 $ 338.51 $1,312.43 $ 88,956.78 $ 333.59 $1,317.35 $ 87,639.43 $ 328.65 $1,322.29 $ 86,317.14 $ 323.69 $1,327.25 $ 84,989.89 $ 318.71 $1,382.23 $ 83,607.66 $ 313.53 $1,387.41 $ 82,220.25 $ 308.33 $1,392.61 $ 80,827.64 $ 303.10 $1,397.84 $ 79,429.80 $ 297.86 $1,403.08 $ 78,026.72 $ 292.60 $1,408.34 $ 76,618.38 $ 287.32 $1,413.62 $ 75,204.76 $ 282.02 $1,418.92 $ 73,785.84 $ 276.70 $1,424.24 $ 72,361.60 $ 271.36 $1,429.58 $ 70,932.01 $ 266.00 $1,434.94 $ 69,497.07 $ 260.61 $1,440.33 $ 68,056.74 $ 255.21 $1,495.73 $ 66,561.01 $ 249.60 $1,501.34 $ 65,059.68 $ 243.97 $1,506.97 $ 63,552.71 $ 238.32 $1,512.62 $ 62,040.09 $ 232.65 $1,518.29 $ 60,521.80 $ 226.96 $1,523.98 $ 58,997.82 $ 221.24 $1,529.70 $ 57,468.12 $ 215.51 $1,535.43 $ 55,932.69 $ 209.75 $1,541.19 $ 54,391.50 $ 203.97 $1,546.97 $ 52,844.52 $ 198.17 $1,552.77 $ 51,291.75 $ 192.34 $1,558.60 $ 49,733.16 $ 186.50 $1,614.44 $ 48,118.71 $ 180.45 $1,620.49 $ 46,498.22 $ 174.37 $1,626.57 $ 44,871.65 $ 168.27 $1,632.67 $ 43,238.98 $ 162.15 $1,638.79 $ 41,600.18 $ 156.00 $1,644.94 $ 39,955.24 $ 149.83 $1,651.11 $ 38,304.14 $ 143.64 $1,657.30 $ 36,646.84 $ 137.43 $1,663.51 $ 34,983.32

$ 131.19 $1,669.75 $ 33,313.57 $ 124.93 $1,676.01 $ 31,637.56 $ 118.64 $1,682.30 $ 29,955.26 $ 112.33 $1,738.61 $ 28,216.65 $ 105.81 $1,745.13 $ 26,471.52 $ 99.27 $1,751.67 $ 24,719.85 $ 92.70 $1,758.24 $ 22,961.61 $ 86.11 $1,764.83 $ 21,196.77 $ 79.49 $1,771.45 $ 19,425.32 $ 72.84 $1,778.10 $ 17,647.23 $ 66.18 $1,784.76 $ 15,862.46 $ 59.48 $1,791.46 $ 14,071.01 $ 52.77 $1,798.17 $ 12,272.83 $ 46.02 $1,804.92 $ 10,467.92 $ 39.25 $1,811.69 $ 8,656.23 $ 32.46 $1,868.48 $ 6,787.75 $ 25.45 $1,875.49 $ 4,912.27 $ 18.42 $1,882.52 $ 3,029.75 $ 11.36 $1,889.58 $ 1,140.17 $ 4.28 $1,896.66 $ (756.49) $ (2.84) $1,903.78 $ (2,660.27) $ (9.98) $1,910.92 $ (4,571.19) $ (17.14) $1,918.08 $ (6,489.27) $ (24.33) $1,925.27 $ (8,414.54) $ (31.55) $1,932.49 $ (10,347.04) $ (38.80) $1,939.74 $ (12,286.78) $ (46.08) $1,947.02 $ (14,233.79)

FIN 691 Graded Valuation Problem Set

Related Documents