Question
In: Finance
1.Determine the payment to amortize the debt. (Round your answer to the nearest cent.) Quarterly payments...
1.Determine the payment to amortize the debt. (Round your answer to the nearest cent.)
Quarterly payments on $19,500 at 3.2% for 6 years.
2.Calculate the present value of the annuity. (Round your answer to the nearest cent.)
$13,000 annually at 5% for 10 years.
3.In the following ordinary annuity, the interest is compounded
with each payment, and the payment is made at the end of the
compounding period.
How much must you invest each month in a mutual fund yielding 13.5%
compounded monthly to become a millionaire in 10 years? (Round your
answer to the nearest cent.)
4.In the following ordinary annuity, the interest is compounded
with each payment, and the payment is made at the end of the
compounding period.
Find the required payment for the sinking fund. (Round your answer
to the nearest cent.)
Monthly deposits earning 5% to accumulate $4000 after 10 years.
Solutions
Expert Solution
| Loan Amortization Schedule | |||||||||
| Enter values | Loan summary | ||||||||
| Loan amount | $ 19,500.00 | Scheduled payment | $ 896.23 | ||||||
| Annual interest rate | 3.20 % | Scheduled number of payments | 24 | ||||||
| Loan period in years | 6 | Actual number of payments | 24 | ||||||
| Number of payments per year | 4 | Total early payments | $ - | ||||||
| Start date of loan | 31-12-2016 | Total interest | $ 81,25,24,687.30 | ||||||
| Optional extra payments | $ - | ||||||||
| Lender name: | |||||||||
| Pmt. No. | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Cumulative Interest |
| 1 | 31-03-2017 | $ 19,500.00 | $ 896.23 | $ - | $ 896.23 | $ 740.23 | $ 156.00 | $ 18,759.77 | $ 156.00 |
| 2 | 01-07-2017 | $ 18,759.77 | $ 896.23 | $ - | $ 896.23 | $ 746.15 | $ 150.08 | $ 18,013.62 | $ 306.08 |
| 3 | 01-10-2017 | $ 18,013.62 | $ 896.23 | $ - | $ 896.23 | $ 752.12 | $ 144.11 | $ 17,261.50 | $ 450.19 |
| 4 | 31-12-2017 | $ 17,261.50 | $ 896.23 | $ - | $ 896.23 | $ 758.14 | $ 138.09 | $ 16,503.36 | $ 588.28 |
| 5 | 31-03-2018 | $ 16,503.36 | $ 896.23 | $ - | $ 896.23 | $ 764.20 | $ 132.03 | $ 15,739.15 | $ 720.31 |
| 6 | 01-07-2018 | $ 15,739.15 | $ 896.23 | $ - | $ 896.23 | $ 770.32 | $ 125.91 | $ 14,968.84 | $ 846.22 |
| 7 | 01-10-2018 | $ 14,968.84 | $ 896.23 | $ - | $ 896.23 | $ 776.48 | $ 119.75 | $ 14,192.36 | $ 965.97 |
| 8 | 31-12-2018 | $ 14,192.36 | $ 896.23 | $ - | $ 896.23 | $ 782.69 | $ 113.54 | $ 13,409.67 | $ 1,079.51 |
| 9 | 31-03-2019 | $ 13,409.67 | $ 896.23 | $ - | $ 896.23 | $ 788.95 | $ 107.28 | $ 12,620.71 | $ 1,186.79 |
| 10 | 01-07-2019 | $ 12,620.71 | $ 896.23 | $ - | $ 896.23 | $ 795.26 | $ 100.97 | $ 11,825.45 | $ 1,287.75 |
| 11 | 01-10-2019 | $ 11,825.45 | $ 896.23 | $ - | $ 896.23 | $ 801.63 | $ 94.60 | $ 11,023.82 | $ 1,382.36 |
| 12 | 31-12-2019 | $ 11,023.82 | $ 896.23 | $ - | $ 896.23 | $ 808.04 | $ 88.19 | $ 10,215.78 | $ 1,470.55 |
| 13 | 31-03-2020 | $ 10,215.78 | $ 896.23 | $ - | $ 896.23 | $ 814.50 | $ 81.73 | $ 9,401.28 | $ 1,552.27 |
| 14 | 01-07-2020 | $ 9,401.28 | $ 896.23 | $ - | $ 896.23 | $ 821.02 | $ 75.21 | $ 8,580.26 | $ 1,627.48 |
| 15 | 01-10-2020 | $ 8,580.26 | $ 896.23 | $ - | $ 896.23 | $ 827.59 | $ 68.64 | $ 7,752.67 | $ 1,696.12 |
| 16 | 31-12-2020 | $ 7,752.67 | $ 896.23 | $ - | $ 896.23 | $ 834.21 | $ 62.02 | $ 6,918.46 | $ 1,758.15 |
| 17 | 31-03-2021 | $ 6,918.46 | $ 896.23 | $ - | $ 896.23 | $ 840.88 | $ 55.35 | $ 6,077.58 | $ 1,813.49 |
| 18 | 01-07-2021 | $ 6,077.58 | $ 896.23 | $ - | $ 896.23 | $ 847.61 | $ 48.62 | $ 5,229.97 | $ 1,862.11 |
| 19 | 01-10-2021 | $ 5,229.97 | $ 896.23 | $ - | $ 896.23 | $ 854.39 | $ 41.84 | $ 4,375.58 | $ 1,903.95 |
| 20 | 31-12-2021 | $ 4,375.58 | $ 896.23 | $ - | $ 896.23 | $ 861.23 | $ 35.00 | $ 3,514.35 | $ 1,938.96 |
| 21 | 31-03-2022 | $ 3,514.35 | $ 896.23 | $ - | $ 896.23 | $ 868.12 | $ 28.11 | $ 2,646.24 | $ 1,967.07 |
| 22 | 01-07-2022 | $ 2,646.24 | $ 896.23 | $ - | $ 896.23 | $ 875.06 | $ 21.17 | $ 1,771.18 | $ 1,988.24 |
| 23 | 01-10-2022 | $ 1,771.18 | $ 896.23 | $ - | $ 896.23 | $ 882.06 | $ 14.17 | $ 889.12 | $ 2,002.41 |
| 24 | 31-12-2022 | $ 889.12 | $ 896.23 | $ - | $ 889.12 | $ 882.00 | $ 7.11 | $ - | $ 2,009.53 |
jeff jeffy answered 2 years agoRelated Solutions
Determine the payment to amortize the debt. (round your answer to the nearest cent.) Quartey payments...
Determine the payment to amortize the debt. (round your answer to
the nearest cent.)
Quartey payments on $15,500 at 3.5% for 6 years.
Find the unpaid balance on the debt. (Round your answer to the
nearest cent)
After 7 years of monthly payments on $180,000 at 3% for 25
years.
1. Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After...
1. Find the unpaid balance on the debt. (Round your answer to
the nearest cent.)
After 5 years of monthly payments on $150,000 at 3% for 25
years.
2. Determine the payment to amortize the debt. (Round your
answer to the nearest cent.)
Quarterly payments on $11,500 at 3.6% for 6 years.
$
3. Determine the payment to amortize the debt. (Round your
answer to the nearest cent.)
Monthly payments on $140,000 at 4% for 25 years.
$
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7...
Find the unpaid balance on the debt. (Round your answer to the
nearest cent.) After 7 years of monthly payments on $150,000 at 4%
for 25 years.
Find the unpaid balance on the debt. (Round your answer to the nearest cent.) After 7...
Find the unpaid balance on the debt. (Round your answer to the
nearest cent.) After 7 years of monthly payments on $150,000 at 5%
for 25 years.
The problem describes a debt to be amortized. (Round your answers to the nearest cent.) A...
The problem describes a debt to be amortized. (Round your
answers to the nearest cent.) A man buys a house for $340,000. He
makes a $150,000 down payment and amortizes the rest of the
purchase price with semiannual payments over the next 5 years. The
interest rate on the debt is 10%, compounded semiannually.
(b) Find the total amount paid for the purchase.
PLEASE ROUND TO THE NEAREST CENT FOR FINAL ANSWER Compare the monthly payments and total loan...
PLEASE ROUND TO THE NEAREST CENT FOR FINAL
ANSWER
Compare the monthly payments and total loan costs for the
following pairs of loan options. Assume that both loans are fixed
rate and have the same closing costs.
You need a $130,000 loan.
Option 1: a 30-year loan at an APR of 9.5%.
Option 2: a 15-year loan at an APR of 8.5%.
--------------------------------------------------------------------
1.) Find the monthly payment for each option.
The monthly payment for option 1 is what?
The...
Please round to the nearest cent for all answers. --------------------------------------------------------------------------------- Compare the monthly payment and total...
Please round to the nearest cent for all
answers.
---------------------------------------------------------------------------------
Compare the monthly payment and total payment for the following
pairs of loan options. Assume that both loans are fixed rate and
have the same closing costs.
You need a $160,000 loan.
Option 1: a 30-year loan at an APR of 7.25%.
Option 2: a 15-year loan at an APR of 6.8%.
----------------------------------------------------------------
Find the monthly payment for each option.
The monthly payment for option 1
iswhat.
The monthly payment...
Find the present value PV of the given investment. (Round your answer to the nearest cent.)...
Find the present value PV of the given investment.
(Round your answer to the nearest cent.)
An investment earns 3% per year and is worth $80,000 after 8
years.
PV=
Calculate the present value of the annuity. (round your answer to the nearest cent.) $1800 monthly...
Calculate the present value of the annuity. (round your answer to
the nearest cent.)
$1800 monthly at 6.1% for 30 years.
Determine the payment to amortize the debt. (round your answer
to the nearest cent.)
Monthly payments on $170,000 at 3% for 25 years.
1. Find the total amount due on the invoice. Round answer to the nearest cent. Taxable...
1.
Find the total amount due on the invoice. Round answer to the
nearest cent.
Taxable Sale
Sales Tax Percent
Invoice Total
$380.98
5.5%
$
2.
Marisa Tallifero bought a cordless phone priced at $49.99. It
was subject to 8.75% sales tax. Round answer to the nearest
cent.
a. What was the sales tax?
$
b. What was the total amount Marisa paid for
the phone?
$
3.
Find the total amount due on the invoice. Round answer to the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Andrew Industries is contemplating issuing a 30-year bond with a coupon rate of 7% (annual coupon...
- ABC Inc., and XYZ Inc., both have 7% coupon bonds outstanding, with semiannual interest payments, and...
- Find one article on a specific aspect of the subject you are most interested in. Use...
- Abascus limited issued 15 year, 14% bonds five years ago. The bond which has a face...
- Fully explain the statement/quote (from Porter’s article, What is Strategy) below and why it is true....
- 1) The yield on a one-year Treasury security is 4.9200%, and the two-year Treasury security has...
- How many total bits are required for a 1-way set associative cache with 16 KB of...
ADVERTISEMENT