Please help to solve question 22-27. Thank you .
Homework Answers
22)Balance at the end of December 5th year 372,785.45
23)Total principal repayment in 5th year 28,043.06
24)Total interest payment in 5th year 19,404.56
25)Balance at the end of December 13th year 90,126.35
26)Total principal repayment in 13th year 41,800.57
27)Total interest payment in 13th year 5,647.05
Add Answer to:
Please help to solve question 22-27. Thank you .
18 3,953.97 Questions 18-27 use the same...
Questions 28-31 use the same data 28 Find mortgage payment N = 5 years, monthly payment,...
Questions 28-31 use the same data 28 Find mortgage payment N = 5 years, monthly payment, annuity due Interest rate = 2.9%, compounded monthly PV = 45,000 FV = 0 Compute PMT Round to 2 decimal places Amortization schedule after 3 years: same data as 228 P1 = 1 29 30 P2 = 36 Balance after 3 years of payments Total principal repayment after 3 yrs of payments Total interest payments after 3 yrs of payments Round to 2 decimal...
You wish to buy a car for $12,000 at a 5% annual interest rate, compounded monthly....
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Instructions You Have Decided to use a 25 year Amortization for your Mortgage. Use this information...
Instructions You Have Decided to use a 25 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.18%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 1 Years and 1 Months. Input all the TVM variables and answers into the fields below. Mortgage Amount From Previous Question Amortization $464372.71 25 Years P/Y C/Y Present Value of...
Section 4 - Mortgage Calculation -- Instructions - You Have Decided to use a 20 year...
Section 4 - Mortgage Calculation -- Instructions - You Have Decided to use a 20 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.21%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 3 Years and 7 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $378102...
please answer all 2pt per question. Show your work clearly to eam partial credit! Read the questions carefully!...
please answer all
2pt per question. Show your work clearly to eam partial credit! Read the questions carefully! Suppose you invest $100, $200, & $300 at the end of year 1 to 3 in the next 3 years and earn 6% each year. What is the future value at the end of year 3? tcompute the PV: using CF function: CO0-0, CO1- 100, C02=200 , C03-300, I-6, CPT NPV= FV,=PV (1r)624.36 Suppose you expect your investment to earn 6 %...
Check my work Assume that you are about to sell property (a vacant parcel of real...
Check my work Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise have no use for. The net-of-sales- commission selling price for the property is $480,000. You are willing to finance this transaction over a 22-year period and have told the buyer that you expect a 14% pretax return on the transaction. The buyer has asked you for a payment schedule under several alternatives. 0.25 points Required: 1. What will be...
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...
i need help on question 3 and 4 Intro You just took out a 15-year traditional...
i
need help on question 3 and 4
Intro You just took out a 15-year traditional fixed-rate mortgage for $500,000 to buy a house. The interest rate is 2.4% (APR) and you have to make payments monthly Attempt 1/10 for 10 pts. Part 1 What is your monthly payment? 3310 Correct Since it's a traditional fixed-rate mortgage, the cash flows are constant and make up an annuity. We can thus use the annuity formula, solved for PMT. Monthly interest rate:r...
You win the lottery! Do you wish to receive $2,000,000 in one payment now, or $167,000...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
1) You wish to borrow $150,000 from a lending institution for the purchase of a house....
1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...
Questions 28-31 use the same data 28 Find mortgage payment N = 5 years, monthly payment, annuity due Interest rate = 2.9%, compounded monthly PV = 45,000 FV = 0 Compute PMT Round to 2 decimal places Amortization schedule after 3 years: same data as 228 P1 = 1 29 30 P2 = 36 Balance after 3 years of payments Total principal repayment after 3 yrs of payments Total interest payments after 3 yrs of payments Round to 2 decimal...
You wish to buy a car for $12,000 at a 5% annual interest rate,
compounded monthly. The loan will be repaid in 5 years with monthly
payments. What is your monthly payment (calculated with the
equations on the next page)? Compare your answer to that obtained
with the built in function, PMT. Be sure to label all cells
appropriately. (There is no need to create a monthly payment table,
simply use the equations on the next page.)
Loans: where: and,...
Instructions You Have Decided to use a 25 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.18%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 1 Years and 1 Months. Input all the TVM variables and answers into the fields below. Mortgage Amount From Previous Question Amortization $464372.71 25 Years P/Y C/Y Present Value of...
Section 4 - Mortgage Calculation -- Instructions - You Have Decided to use a 20 year Amortization for your Mortgage. Use this information to find the MONTHLY mortgage PAYMENT using the mortgage amount from previous section and a rate of 3.21%. You must also determine the amount of INTEREST, PRINCIPAL and BALANCE owing for the mortgage after 3 Years and 7 Months. Input all the TVM variables and answers into the fields below. Amortization Mortgage Amount From Previous Question $378102...
please answer all
2pt per question. Show your work clearly to eam partial credit! Read the questions carefully! Suppose you invest $100, $200, & $300 at the end of year 1 to 3 in the next 3 years and earn 6% each year. What is the future value at the end of year 3? tcompute the PV: using CF function: CO0-0, CO1- 100, C02=200 , C03-300, I-6, CPT NPV= FV,=PV (1r)624.36 Suppose you expect your investment to earn 6 %...
Check my work Assume that you are about to sell property (a vacant parcel of real estate) you own but otherwise have no use for. The net-of-sales- commission selling price for the property is $480,000. You are willing to finance this transaction over a 22-year period and have told the buyer that you expect a 14% pretax return on the transaction. The buyer has asked you for a payment schedule under several alternatives. 0.25 points Required: 1. What will be...
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...
i
need help on question 3 and 4
Intro You just took out a 15-year traditional fixed-rate mortgage for $500,000 to buy a house. The interest rate is 2.4% (APR) and you have to make payments monthly Attempt 1/10 for 10 pts. Part 1 What is your monthly payment? 3310 Correct Since it's a traditional fixed-rate mortgage, the cash flows are constant and make up an annuity. We can thus use the annuity formula, solved for PMT. Monthly interest rate:r...
You win the lottery! Do you wish to receive $2,000,000 in one
payment now, or $167,000 per year for 30 years? To help you in your
decision, estimate the present value of the second option assuming
constant annual interest rates of 6%, 8%, and 10%. Expound on your
decision within a text box. (You may use the built-in PV function
within Excel)
Loans: where: and, interest due at the end of each month A = payment P = principal (amount...
1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago