Homework Answers
Calculate the amortization schedule as follows:
Formulas:
Add Answer to:
Question 13 12 pts Suppose you arrange a 4 month, $12000 loan with end-of-month payments for...
6 [12 pts.] 4.1#5: Working similar to the above, a fixed APR loan charges interest at the end of ...
6 [12 pts.] 4.1#5: Working similar to the above, a fixed APR loan charges interest at the end of each cycle that is equal to the specified fixed percentage of what is currently owed. (a.) Use this idea to recursively define a sequence that models how much is owed upon a loan of $1000 that accrues 2% interest at the end of every month (24% APR-not too far different from that of many credit cards), and is paid off at...
Question 1 -Interest & loan Sue will need $120,000 to refurbish her house at the corner...
Question 1 -Interest & loan Sue will need $120,000 to refurbish her house at the corner of a main road into a cake shop in 5 years. She has a saving account which carn 3.47 % p.a. compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b)...
should be explain it on excel Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
Suppose that you plan to borrow $20,000 student loans to attend UM-Dearborn. You are considering borrowing...
Suppose that you plan to borrow $20,000 student loans to attend UM-Dearborn. You are considering borrowing the loan from SallieMae. SallieMae offers two options for the repayment of your loan. One is the deferred repayment option and the other is interest repayment option. The APR for the deferred repayment option is 6.75% and the APR for the interest repayment option is 5.75%. You plan to finish your undergraduate study in UM-Dearborn within five years. The two repayment options are described...
only need the second part B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a...
only need the second part
B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3 equal installments at the end of each of the next 3 years. How large would your payments be, how much of the first payment would represent interest, how much would be principal, and what would your ending balance be after the first year? 8% $30,000 $0 FV PMT $8,386.69 3 Loan...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the comer of a main road into a cake shop in 5 years. She has a saving account which cam 3.47% p.a compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b)...
The purpose of this question is to give you experience creating an amortization schedule for a...
The purpose of this question is to give you experience
creating an amortization schedule for a loan. As noted by
Investopedia: ‘An amortization schedule is a complete table of
periodic loan payments, showing the amount of principal and the
amount of interest that comprise each payment until the loan is
paid off at the end of its term. While each periodic payment is the
same amount early in the schedule, the majority of each payment is
interest; later in the...
please help Questions: Suppose that you plan to borrow $20,000 student loans to attend UM-Dearbom. You...
please help
Questions: Suppose that you plan to borrow $20,000 student loans to attend UM-Dearbom. You are considering borrowing the loan from SallicMac. Sallic Mac offers two options for the repayment of your loan. One is the deferred repayment option and the other is interest repayment option. The APR for the deferred repayment option is 5.75% and the APR for the interest repayment option is 4.75%. You plan to finish your undergraduate study in UM-Dearbom within four years. The two...
2. To illustrate with the simplest case of annual payments, suppose you borrow $22,000 at 12...
2. To illustrate with the simplest case of annual payments, suppose you borrow $22,000 at 12 percent compound annual interest to be repaid over the next six years. Equal installment payments are required at the end of each year. In addition, these payments must be sufficient in amount to repay the $22,000 together with providing the lender with a 12 percent return. Please determine the annual payment, and amortization schedule.
On 1/1/21, you purchase a used car for $5,000 with a 12% loan (note) payable monthly....
On 1/1/21, you purchase a used car for $5,000 with a 12% loan (note) payable monthly. Payments of principal and interest are made at the end of each month for the next three years. Required a. Compute the amount of your monthly payment. b. Create an effective interest amortization table in Excel for the entire life of the car loan payable using the following columns: payment number, payment date, beginning carrying value, effective interest rate, interest expense, cash paid (principal...
6 [12 pts.] 4.1#5: Working similar to the above, a fixed APR loan charges interest at the end of each cycle that is equal to the specified fixed percentage of what is currently owed. (a.) Use this idea to recursively define a sequence that models how much is owed upon a loan of $1000 that accrues 2% interest at the end of every month (24% APR-not too far different from that of many credit cards), and is paid off at...
Question 1 -Interest & loan Sue will need $120,000 to refurbish her house at the corner of a main road into a cake shop in 5 years. She has a saving account which carn 3.47 % p.a. compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b)...
should be explain it on excel
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (10 pts) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. What initial principal will this repay? (b) Assume annual car payments of $6000 for 4 years and an interest rate of 9% per year. 1. What initial principal will this repay? (c) Assume monthly car...
only need the second part
B SECTION 5-18 Amortization 1. Suppose you borrowed $30,000 on a student loan at a rate of 8% and must repay it in 3 equal installments at the end of each of the next 3 years. How large would your payments be, how much of the first payment would represent interest, how much would be principal, and what would your ending balance be after the first year? 8% $30,000 $0 FV PMT $8,386.69 3 Loan...
Question 1 - Interest & loan Sue will need $120,000 to refurbish her house at the comer of a main road into a cake shop in 5 years. She has a saving account which cam 3.47% p.a compounding quarterly and she is able to deposit $800 into that account at the end of each month for 5 years. a) Will Sue have enough money after 5 years? If not, how much is in short? Show all calculations. (4 marks) b)...
The purpose of this question is to give you experience
creating an amortization schedule for a loan. As noted by
Investopedia: ‘An amortization schedule is a complete table of
periodic loan payments, showing the amount of principal and the
amount of interest that comprise each payment until the loan is
paid off at the end of its term. While each periodic payment is the
same amount early in the schedule, the majority of each payment is
interest; later in the...
please help
Questions: Suppose that you plan to borrow $20,000 student loans to attend UM-Dearbom. You are considering borrowing the loan from SallicMac. Sallic Mac offers two options for the repayment of your loan. One is the deferred repayment option and the other is interest repayment option. The APR for the deferred repayment option is 5.75% and the APR for the interest repayment option is 4.75%. You plan to finish your undergraduate study in UM-Dearbom within four years. The two...
2. To illustrate with the simplest case of annual payments, suppose you borrow $22,000 at 12 percent compound annual interest to be repaid over the next six years. Equal installment payments are required at the end of each year. In addition, these payments must be sufficient in amount to repay the $22,000 together with providing the lender with a 12 percent return. Please determine the annual payment, and amortization schedule.
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago