Description
Hello,
I need someone experienced with Excel to help complete a homework assignment and test for my Small Business Economics & Management class. THE HOMEWORK ASSIGNMENT IS CALLED "AMORTIZATION" AND THE TEST IS CALLED "EXAM 2". Attached to this question are various images that will help you navigate the website. You will have full access to the website, and can use the resources in the Course Content folder.
I need a 90% and above on the test and a similar result on the homework, in addition to following the guidelines. DO NOT SUBMIT DIRECTLY OR I WILL HAVE TO ASK FOR A REFUND.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Here is the excel
Amortization is the process of paying off debt in fixed timely (annual, monthly, quarterly, etc) payments. The
table below is one tool to determine how much it will take to pay off a certain debt at a given interest rate over a
certain number of years. Take for instance the first row for a one year loan at an interest rate of 7%. At the end of
the year you would pay back 107% of the amount you borrowed if your interest rate was 7%. If you had a 6% loan
that you paid off over 10 years you'd have annual payments of 13.59% of the principle for 10 years. This would
mean that over the life of the loan you'd pay 135.9% of what you borrowed. That additional 35.9% can be
considered the cost of borrowing money. The table graphic below is a standard table that can be used. To the
right there is an additional table. On the coming tabs you can also use an excel function. This will make it easier to
determine payments that are monthly.
Note that when you do monthly payments you need to divide annual interest rates by 12 and
multiply the number of periods by 12 to covert years to months
c) payments. The
en interest rate over a
te of 7%. At the end of
%. If you had a 6% loan
0 years. This would
l 35.9% can be
an be used. To the
s will make it easier to
Rate
# of Periods
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
35
40
45
50
100
1,0%
1,010
0,508
0,340
0,256
0,206
0,173
0,149
0,131
0,117
0,106
0,096
0,089
0,082
0,077
0,072
0,068
0,064
0,061
0,058
0,055
0,053
0,051
0,049
0,047
0,045
0,044
0,042
0,041
0,040
0,039
0,034
0,030
0,028
0,026
0,016
1,5%
1,015
0,511
0,343
0,259
0,209
0,176
0,152
0,134
0,120
0,108
0,099
0,092
0,085
0,080
0,075
0,071
0,067
0,064
0,061
0,058
0,056
0,054
0,052
0,050
0,048
0,047
0,045
0,044
0,043
0,042
0,037
0,033
0,031
0,029
0,019
2,0%
1,020
0,515
0,347
0,263
0,212
0,179
0,155
0,137
0,123
0,111
0,102
0,095
0,088
0,083
0,078
0,074
0,070
0,067
0,064
0,061
0,059
0,057
0,055
0,053
0,051
0,050
0,048
0,047
0,046
0,045
0,040
0,037
0,034
0,032
0,023
2,5%
1,025
0,519
0,350
0,266
0,215
0,182
0,157
0,139
0,125
0,114
0,105
0,097
0,091
0,086
0,081
0,077
0,073
0,070
0,067
0,064
0,062
0,060
0,058
0,056
0,054
0,053
0,051
0,050
0,049
0,048
0,043
0,040
0...