Question

In: Math

This exercise is designed to be solved using technology such as calculators or computer spreadsheets. You...

This exercise is designed to be solved using technology such as calculators or computer spreadsheets.

You borrow $18,000 with a term of four years at an APR of 8%. Make an amortization table. How much equity have you built up halfway through the term? (Round your answer to two decimal places.)

Solutions

Expert Solution

The following table captures the entire cash flow during the 48 months

Month Payment Interest Paid Principal Paid Balance
Original Principal 18000 0 18000
Loan term (Yrs) 4 1 439.4326021 $120.00 $319.43 $17,680.57
APR 8% 2 439.4326021 $117.87 $321.56 $17,359.01
Payments per Yr 12 3 439.4326021 $115.73 $323.71 $17,035.30
4 439.4326021 $113.57 $325.86 $16,709.44
Instalment $439.43 5 439.4326021 $111.40 $328.04 $16,381.40
6 439.4326021 $109.21 $330.22 $16,051.18
7 439.4326021 $107.01 $332.42 $15,718.75
8 439.4326021 $104.79 $334.64 $15,384.11
9 439.4326021 $102.56 $336.87 $15,047.24
10 439.4326021 $100.31 $339.12 $14,708.12
11 439.4326021 $98.05 $341.38 $14,366.74
12 439.4326021 $95.78 $343.65 $14,023.09
13 439.4326021 $93.49 $345.95 $13,677.14
14 439.4326021 $91.18 $348.25 $13,328.89
15 439.4326021 $88.86 $350.57 $12,978.32
16 439.4326021 $86.52 $352.91 $12,625.41
17 439.4326021 $84.17 $355.26 $12,270.14
18 439.4326021 $81.80 $357.63 $11,912.51
19 439.4326021 $79.42 $360.02 $11,552.50
20 439.4326021 $77.02 $362.42 $11,190.08
21 439.4326021 $74.60 $364.83 $10,825.25
22 439.4326021 $72.17 $367.26 $10,457.98
23 439.4326021 $69.72 $369.71 $10,088.27
24 439.4326021 $67.26 $372.18 $9,716.09
25 439.4326021 $64.77 $374.66 $9,341.44
26 439.4326021 $62.28 $377.16 $8,964.28
27 439.4326021 $59.76 $379.67 $8,584.61
28 439.4326021 $57.23 $382.20 $8,202.41
29 439.4326021 $54.68 $384.75 $7,817.66
30 439.4326021 $52.12 $387.31 $7,430.34
31 439.4326021 $49.54 $389.90 $7,040.44
32 439.4326021 $46.94 $392.50 $6,647.95
33 439.4326021 $44.32 $395.11 $6,252.84
34 439.4326021 $41.69 $397.75 $5,855.09
35 439.4326021 $39.03 $400.40 $5,454.69
36 439.4326021 $36.36 $403.07 $5,051.62
37 439.4326021 $33.68 $405.76 $4,645.87
38 439.4326021 $30.97 $408.46 $4,237.41
39 439.4326021 $28.25 $411.18 $3,826.22
40 439.4326021 $25.51 $413.92 $3,412.30
41 439.4326021 $22.75 $416.68 $2,995.61
42 439.4326021 $19.97 $419.46 $2,576.15
43 439.4326021 $17.17 $422.26 $2,153.89
44 439.4326021 $14.36 $425.07 $1,728.82
45 439.4326021 $11.53 $427.91 $1,300.91
46 439.4326021 $8.67 $430.76 $870.15
47 439.4326021 $5.80 $433.63 $436.52
48 439.4326021 $2.91 $436.52 ($0.00)

The monthly payment is calculated as the excel formula PMT(8%/12, 4*12, -18000)

The Interest paid is calculated as IPMT(8%/12, i, 4*12, -18000) where i denotes the months from 1 to 48.

The Principal paid is calculated as PPMT(8%/12, i, 4*12, -18000)

The Balance is calculated as the successive reductions of Principa oaid from the original principal.

Thus, the equity built to 24 months can be calculated now. $9,716.09 is the balance after 24 months, with an initial value of $18,000. Thus the equity built is $18,000 - $9,716.09 = $8283.91


Related Solutions

This exercise is designed to be solved using technology such as calculators or computer spreadsheets. You...
This exercise is designed to be solved using technology such as calculators or computer spreadsheets. You borrow $18,000 with a term of four years at an APR of 8%. Make an amortization table. How much equity have you built up halfway through the term? (Round your answer to two decimal places.)
This exercise is designed to be solved using technology such as calculators or computer spreadsheets. You...
This exercise is designed to be solved using technology such as calculators or computer spreadsheets. You borrow $18,000 with a term of four years at an APR of 8%. Make an amortization table. How much equity have you built up halfway through the term? (Round your answer to two decimal places.)
The following exercise is designed to be solved using technology such as calculators or computer spreadsheets....
The following exercise is designed to be solved using technology such as calculators or computer spreadsheets. Interest paid on a home mortgage is normally tax deductible. That is, you can subtract the total mortgage interest paid over the year in determining your taxable income. This is one advantage of buying a home. Suppose you take out a 30-year home mortgage for $250,000 at an APR of 8% compounded monthly. The mortgage payments details for the first year are given below....
The following exercise is designed to be solved using technology such as calculators or computer spreadsheets....
The following exercise is designed to be solved using technology such as calculators or computer spreadsheets. Make a table showing the sample size needed to get a given margin of error ranging from 2% to 3% in steps of 0.1 percentage point. Assume that the level of confidence is 95% using the rule of thumb for the margin of error, and round to the nearest whole number. Margin of Error Sample Size 2% 2.1% 2.2% 2.3% 2.4% 2.5% 2.6% 2.7%...
The exercise involving data in this and subsequent sections were designed to be solved using Excel....
The exercise involving data in this and subsequent sections were designed to be solved using Excel. The following estimated regression equation is based on 30 observations. y = 18.3 + 3.6x1 - 2.2x2 +7.8x3 + 2.9x4 The values of SST and SSR are 1,801 and 1,758, respectively. a. Compute R2 (o 3 decimals). __.976_____ b. Compute R2a (to 3 decimals). ____________
This exercise is to be solved using program R. Information about worms that inhabit various conditions...
This exercise is to be solved using program R. Information about worms that inhabit various conditions was obtained (Worms.txt). Suppose that the mean of Worm.density is 5, then you want to conduct a statistical test. (H0: mu=5 vs H1: mu≠5) Find t statistics. Compare t statistics with t distribution table and conclude with a significant level of 5%. Show the code and Rhistory. Worms.txt Field.Name Area Slope Vegetation Soil.pH Damp Worm.density Nashs.Field 3.6 11 Grassland 4.1 F 4 Silwood.Bottom 5.1...
HAS TO BE SOLVED IN EXCEL Exercise 5A–1 High-Low Method LO5–11 NEEDS to be solved and...
HAS TO BE SOLVED IN EXCEL Exercise 5A–1 High-Low Method LO5–11 NEEDS to be solved and shown in excel The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel’s business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 1,736 $  4,127...
Opportunity Cost Exercise. Please show how you solved the questions.    You have been working for...
Opportunity Cost Exercise. Please show how you solved the questions.    You have been working for your brother (owner of a Down Under Sandwich Shoppe). The franchise company is now offering you a chance to franchise one of their new Big Bird Stick-e-Chicken shops (which sells their honey-roasted chicken-on-a-stick). You estimate your business can gross 45% of Down Under’s $500,000 sales. Shop space is available between Down Under Sandwiches and Little Nero Salads that leases $8,400 a year plus a...
What is an example of a problem that you feel could be solved using a regression...
What is an example of a problem that you feel could be solved using a regression model? Try to think of one in your chosen career field or one that you have interest in solving. In your post, specify what the problem is that you’d like to solve and how you would specify a model that would address the problem. What variables might impact on the outcome variable? Are they quantitative or categorical? You don’t have to actually collect data...
Assume that you manage a firm that sells calculators. You want to sell calculators to both...
Assume that you manage a firm that sells calculators. You want to sell calculators to both commercial users and home users, and so you have developed 2 types of calculators - fancy and basic calculators. Each customer type has the following valuations for each type of calculator: Home User Commercial User Fancy Calculator $100 $200 Basic Calculator $30 $50 If you have an 100 home users and 100 commercial users that at most will buy 1 calculator each, you will...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT