Question

In: Finance

You just took out a 10 year commercial real estate loan for your business. The loan...

You just took out a 10 year commercial real estate loan for your business. The loan amount is $250,000 and the interest rate is 3.5%. How many periods (months) will it take you to pay off $100,000 of the principal loan? Round your answer to the closest whole number. PLEASE answer in excel with appropriate excel formulas

Solutions

Expert Solution

At months 54 Principal of 100,000 is paid off. as per following table.

A B C D E
Beginning Balance PMT=PMT(3.5%/12,120,A1) Interest= =A1*3.5%/12 Principal Part= PMT - Interest Ending balance = Beginning Balance - Principal Part of PMT
1 250000 $2,472.15 729.1667 $1,742.98 $248,257.02
2 $248,257.02 $2,472.15 724.083 $1,748.06 $246,508.96
3 $246,508.96 $2,472.15 718.9845 $1,753.16 $244,755.79
4 $244,755.79 $2,472.15 713.8711 $1,758.28 $242,997.52
5 $242,997.52 $2,472.15 708.7428 $1,763.40 $241,234.11
6 $241,234.11 $2,472.15 703.5995 $1,768.55 $239,465.57
7 $239,465.57 $2,472.15 698.4412 $1,773.71 $237,691.86
8 $237,691.86 $2,472.15 693.2679 $1,778.88 $235,912.98
9 $235,912.98 $2,472.15 688.0795 $1,784.07 $234,128.92
10 $234,128.92 $2,472.15 682.876 $1,789.27 $232,339.65
11 $232,339.65 $2,472.15 677.6573 $1,794.49 $230,545.16
12 $230,545.16 $2,472.15 672.4234 $1,799.72 $228,745.43
13 $228,745.43 $2,472.15 667.1742 $1,804.97 $226,940.46
14 $226,940.46 $2,472.15 661.9097 $1,810.24 $225,130.22
15 $225,130.22 $2,472.15 656.6298 $1,815.52 $223,314.71
16 $223,314.71 $2,472.15 651.3346 $1,820.81 $221,493.89
17 $221,493.89 $2,472.15 646.0239 $1,826.12 $219,667.77
18 $219,667.77 $2,472.15 640.6977 $1,831.45 $217,836.32
19 $217,836.32 $2,472.15 635.3559 $1,836.79 $215,999.53
20 $215,999.53 $2,472.15 629.9986 $1,842.15 $214,157.38
21 $214,157.38 $2,472.15 624.6257 $1,847.52 $212,309.86
22 $212,309.86 $2,472.15 619.2371 $1,852.91 $210,456.95
23 $210,456.95 $2,472.15 613.8328 $1,858.31 $208,598.64
24 $208,598.64 $2,472.15 608.4127 $1,863.73 $206,734.90
25 $206,734.90 $2,472.15 602.9768 $1,869.17 $204,865.74
26 $204,865.74 $2,472.15 597.5251 $1,874.62 $202,991.11
27 $202,991.11 $2,472.15 592.0574 $1,880.09 $201,111.02
28 $201,111.02 $2,472.15 586.5738 $1,885.57 $199,225.45
29 $199,225.45 $2,472.15 581.0742 $1,891.07 $197,334.38
30 $197,334.38 $2,472.15 575.5586 $1,896.59 $195,437.79
31 $195,437.79 $2,472.15 570.0269 $1,902.12 $193,535.67
32 $193,535.67 $2,472.15 564.479 $1,907.67 $191,628.00
33 $191,628.00 $2,472.15 558.915 $1,913.23 $189,714.77
34 $189,714.77 $2,472.15 553.3348 $1,918.81 $187,795.96
35 $187,795.96 $2,472.15 547.7382 $1,924.41 $185,871.55
36 $185,871.55 $2,472.15 542.1254 $1,930.02 $183,941.53
37 $183,941.53 $2,472.15 536.4961 $1,935.65 $182,005.88
38 $182,005.88 $2,472.15 530.8505 $1,941.30 $180,064.58
39 $180,064.58 $2,472.15 525.1884 $1,946.96 $178,117.62
40 $178,117.62 $2,472.15 519.5097 $1,952.64 $176,164.99
41 $176,164.99 $2,472.15 513.8145 $1,958.33 $174,206.66
42 $174,206.66 $2,472.15 508.1027 $1,964.04 $172,242.61
43 $172,242.61 $2,472.15 502.3743 $1,969.77 $170,272.84
44 $170,272.84 $2,472.15 496.6291 $1,975.52 $168,297.32
45 $168,297.32 $2,472.15 490.8672 $1,981.28 $166,316.04
46 $166,316.04 $2,472.15 485.0885 $1,987.06 $164,328.98
47 $164,328.98 $2,472.15 479.2929 $1,992.85 $162,336.13
48 $162,336.13 $2,472.15 473.4804 $1,998.67 $160,337.46
49 $160,337.46 $2,472.15 467.6509 $2,004.50 $158,332.97
50 $158,332.97 $2,472.15 461.8045 $2,010.34 $156,322.63
51 $156,322.63 $2,472.15 455.941 $2,016.21 $154,306.42
52 $154,306.42 $2,472.15 450.0604 $2,022.09 $152,284.33
53 $152,284.33 $2,472.15 444.1626 $2,027.98 $150,256.35
54 $150,256.35 $2,472.15 438.2477 $2,033.90 $148,222.45
55 $148,222.45 $2,472.15 432.3155 $2,039.83 $146,182.62
56 $146,182.62 $2,472.15 426.366 $2,045.78 $144,136.84
57 $144,136.84 $2,472.15 420.3991 $2,051.75 $142,085.09
58 $142,085.09 $2,472.15 414.4149 $2,057.73 $140,027.36
59 $140,027.36 $2,472.15 408.4131 $2,063.73 $137,963.63
60 $137,963.63 $2,472.15 402.3939 $2,069.75 $135,893.87
61 $135,893.87 $2,472.15 396.3571 $2,075.79 $133,818.08
62 $133,818.08 $2,472.15 390.3027 $2,081.84 $131,736.24
63 $131,736.24 $2,472.15 384.2307 $2,087.92 $129,648.32
64 $129,648.32 $2,472.15 378.1409 $2,094.01 $127,554.32
65 $127,554.32 $2,472.15 372.0334 $2,100.11 $125,454.20
66 $125,454.20 $2,472.15 365.9081 $2,106.24 $123,347.97
67 $123,347.97 $2,472.15 359.7649 $2,112.38 $121,235.58
68 $121,235.58 $2,472.15 353.6038 $2,118.54 $119,117.04
69 $119,117.04 $2,472.15 347.4247 $2,124.72 $116,992.32
70 $116,992.32 $2,472.15 341.2276 $2,130.92 $114,861.40
71 $114,861.40 $2,472.15 335.0124 $2,137.13 $112,724.27
72 $112,724.27 $2,472.15 328.7791 $2,143.37 $110,580.90
73 $110,580.90 $2,472.15 322.5276 $2,149.62 $108,431.28
74 $108,431.28 $2,472.15 316.2579 $2,155.89 $106,275.39
75 $106,275.39 $2,472.15 309.9699 $2,162.18 $104,113.21
76 $104,113.21 $2,472.15 303.6635 $2,168.48 $101,944.73
77 $101,944.73 $2,472.15 297.3388 $2,174.81 $99,769.92
78 $99,769.92 $2,472.15 290.9956 $2,181.15 $97,588.77
79 $97,588.77 $2,472.15 284.6339 $2,187.51 $95,401.26
80 $95,401.26 $2,472.15 278.2537 $2,193.89 $93,207.37
81 $93,207.37 $2,472.15 271.8548 $2,200.29 $91,007.07
82 $91,007.07 $2,472.15 265.4373 $2,206.71 $88,800.36
83 $88,800.36 $2,472.15 259.0011 $2,213.15 $86,587.22
84 $86,587.22 $2,472.15 252.5461 $2,219.60 $84,367.62
85 $84,367.62 $2,472.15 246.0722 $2,226.07 $82,141.54
86 $82,141.54 $2,472.15 239.5795 $2,232.57 $79,908.98
87 $79,908.98 $2,472.15 233.0678 $2,239.08 $77,669.90
88 $77,669.90 $2,472.15 226.5372 $2,245.61 $75,424.29
89 $75,424.29 $2,472.15 219.9875 $2,252.16 $73,172.13
90 $73,172.13 $2,472.15 213.4187 $2,258.73 $70,913.40
91 $70,913.40 $2,472.15 206.8308 $2,265.32 $68,648.09
92 $68,648.09 $2,472.15 200.2236 $2,271.92 $66,376.16
93 $66,376.16 $2,472.15 193.5971 $2,278.55 $64,097.61
94 $64,097.61 $2,472.15 186.9514 $2,285.20 $61,812.42
95 $61,812.42 $2,472.15 180.2862 $2,291.86 $59,520.56
96 $59,520.56 $2,472.15 173.6016 $2,298.55 $57,222.01
97 $57,222.01 $2,472.15 166.8975 $2,305.25 $54,916.76
98 $54,916.76 $2,472.15 160.1739 $2,311.97 $52,604.79
99 $52,604.79 $2,472.15 153.4306 $2,318.72 $50,286.07
100 $50,286.07 $2,472.15 146.6677 $2,325.48 $47,960.60
101 $47,960.60 $2,472.15 139.8851 $2,332.26 $45,628.33
102 $45,628.33 $2,472.15 133.0826 $2,339.06 $43,289.27
103 $43,289.27 $2,472.15 126.2604 $2,345.89 $40,943.38
104 $40,943.38 $2,472.15 119.4182 $2,352.73 $38,590.65
105 $38,590.65 $2,472.15 112.5561 $2,359.59 $36,231.06
106 $36,231.06 $2,472.15 105.6739 $2,366.47 $33,864.59
107 $33,864.59 $2,472.15 98.77172 $2,373.37 $31,491.22
108 $31,491.22 $2,472.15 91.84938 $2,380.30 $29,110.92
109 $29,110.92 $2,472.15 84.90685 $2,387.24 $26,723.68
110 $26,723.68 $2,472.15 77.94406 $2,394.20 $24,329.48
111 $24,329.48 $2,472.15 70.96097 $2,401.19 $21,928.29
112 $21,928.29 $2,472.15 63.95751 $2,408.19 $19,520.10
113 $19,520.10 $2,472.15 56.93363 $2,415.21 $17,104.89
114 $17,104.89 $2,472.15 49.88926 $2,422.26 $14,682.63
115 $14,682.63 $2,472.15 42.82434 $2,429.32 $12,253.31
116 $12,253.31 $2,472.15 35.73882 $2,436.41 $9,816.90
117 $9,816.90 $2,472.15 28.63263 $2,443.51 $7,373.39
118 $7,373.39 $2,472.15 21.50571 $2,450.64 $4,922.75
119 $4,922.75 $2,472.15 14.35801 $2,457.79 $2,464.96
120 $2,464.96 $2,472.15 7.189459 $2,464.96 ($0.00)

Best of Luck. God Bless


Related Solutions

You just took out a 10-year commercial real estate loan for your business. The loan amount...
You just took out a 10-year commercial real estate loan for your business. The loan amount is $250,000 and the interest rate is 3.5%. How many periods (months) will it take you to pay off $100,000 of the principal of the loan? Round your answer to the closest whole number. PLEASE SHOW WORK
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan...
Five years ago you took out a 10-year amortizing loan to purchase an apartment. The loan has 4.0% APR with monthly payments of $1,800. How much do you owe on the loan today? The remaining loan balance is $________. (round to the nearest dollar) How much interest did you pay on the loan in the past year? The interest paid in year five was $______. (round to the nearest dollar) Over the entire period of 10 years, how much interest...
Four years ago, your friend took out a 10-year loan for $200,000 from BOA Bank at...
Four years ago, your friend took out a 10-year loan for $200,000 from BOA Bank at a stated interest rate of 10% p.a. with interest compounded quarterly. She has been making equal, quarterly payments on the loan during this time and now wishes to repay the loan in full. The amount that she needs to repay the bank today is closest to: a) $72,524. b) $104,012. c) $142,494. d) $187,678.
Your business has just taken out a 1-year installment loan for $72,500 at a nominal rate...
Your business has just taken out a 1-year installment loan for $72,500 at a nominal rate of 6.5% but with equal end-of-month payments. What percentage of the 2nd monthly payment will go toward the repayment of principal? Select the correct answer. a. 94.23% b. 96.23% c. 98.23% d. 95.23% e. 97.23%
a) You took out a one-year loan for $3000 and agreed to pay it in three...
a) You took out a one-year loan for $3000 and agreed to pay it in three equal installments, one payment at the end of 1 months, a second payment at the end of 2 months, and a last payment at the end of the year. What is the size of each payment? Assume interest rate is 9%. b) In part (a), suppose that you made three non-equal payments: the first was $600 at the end of 1 month, the second...
When you purchased your​ car, you took out a​ five-year annual-payment loan with an interest rate...
When you purchased your​ car, you took out a​ five-year annual-payment loan with an interest rate of 5.9% per year. The annual payment on the car is $5,000. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following​ scenarios? a. You have owned the car for one year​ (so there are four years left on the​ loan)? b. You have owned the...
1. When you purchased your car, you took out a five-year annual-payment loan with an interest...
1. When you purchased your car, you took out a five-year annual-payment loan with an interest rate of 6.5% per year. The annual payment on the car is $4,500. You have just made a payment and have now decided to pay off the loan by repaying the outstanding balance. What is the payoff amount for the following scenarios? a. You have owned the car for the one year (so there are four year left on the loan)? answer: $15,416.09 b....
A business will take out a 10-year loan of $150,000. The interest rate is 10% per...
A business will take out a 10-year loan of $150,000. The interest rate is 10% per year and the loan calls for a $15,000 reduction in principal each year. What is the total payment in year 3? Please show work by using appropriate formulas. Thank you.
You just took a $90,000, 10 years loan. The annual percentage rate (APR) is 8%. You...
You just took a $90,000, 10 years loan. The annual percentage rate (APR) is 8%. You are obligated to pay a flat payment at the end of each QUARTER. (a) Make a loan amortization table; (b) Plot a figure to show the flat payment, payment to interest, and payment in each quarter. SHOW IN EXCEL PLEASE
Scheerer, a licensed real estate agent, and Fisher, a manager of commercial real estate, worked together...
Scheerer, a licensed real estate agent, and Fisher, a manager of commercial real estate, worked together on past real estate deals and knew each other from their business relationship. Scheerer gave Fisher a tip that some commercial real estate was on the market that Fisher might be interested in purchasing. Fisher made an offer to buy the properties and, with this offer, orally contracted for a 2 percent commission for Scheerer from the seller and another 2 percent commission from...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT