Solve all of the following problems with Excel. Please use formulas in excel to solve.
(2) (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 payments of $500 per month for 4 years and an interest rate of 7% per year.
1. What initial principal will this repay?
2. Prepare a loan payment schedule showing the payments and interest for the life of the loan.
(3) (a) A 10-year mortgage for $95,000 is issued at a 6% annual interest rate.
(a) What is the monthly payment?
(b) How long does it take to pay off the mortgage, if $1500 per month is paid?
(c) What is the monthly payment, if the interest rate is 0.5% per month?
(4) Calculate the Issuance Price of a 10 year bond with a face value of $250,000, stated interest rate of 4% to yield 5%. Interest payments are paid semiannually.
1 Calculate the price in excel
2 Prepare a bond amortization schedule using the straight line method
3 Prepare a bond amortization schedule using the effective interest method
Please note: For all of the above please label your work. Work will be graded on accuracy and the utilization of excel throughout your work.
ANSWER:
2)a)
b)
It is the same as (a) because the monthly values have simply been converted into annual figures
c
3)
a)
b)
Therefore, 57 monthly repayments reqd.
Note : As per the HOMEWORKLIB RULES one question is enough .so please re-post the other question .thank you
Solve all of the following problems with Excel. Please use formulas in excel to solve. (2) (a) Assume monthly car payments of $500 per month for 4 years and an interest rate of 0.75% per month. 1. Wha...
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...
Consider a 30-year adjustable rate mortgage (ARM), which requires the borrower to make monthly payments at the end of each month. The mortgage amount is $432,000 and the APR on the mortgage is 3.65% for the first 10 years and then 3.87% for the next 20 years. Prepare a loan amortization schedule for this mortgage. Assume that the mortgage closing date is October 1, 2018. Among other things, the following columns should be included. (50) (i) Date (ii) Beginning Balance...
1. Complete the following table. Number of Annual Payments or Years Present Value Interest Rate Future Value Annuity 10 $250.00 12% 20 S1,000 25 S500,000 30 S1,000,000 2. You just started working and you planned to save $5,000 every year in your retirement account. How much money will you have in your retirement account once you retire in 40 years? Your retirement account pays 4% interest rate per year. 3. You just retired with S1,000,000 savings. You'd like to receive...
In a fixed-rate mortgage amortization schedule of monthly mortgage payments A. The amount of interest in each payment is equal to the amount of principal paid B. Both B and C are true C. In the early years, principal repayment exceeds interest payments D. In the early years, interest payments exceed principals repayments
i need part B and the rest on excel Question 1 Prepare the amortization schedule for a thirty-year loan of $100,000. The APR is 3% and the loan calls for equal monthly payments. The following table shows how you should prepare the amortization schedule for the loan. a. Interest Principal Ending Month lPayment Payment Payment Balance Beginning ota S100,000.00 b. Use the annuity formula to find how much principal you still owe to the bank at the end of the...
Calculate a 30 year amortization schedule in excel for the purchase of an office building. Here are the details: The building costs $250,000. You are able to obtain a mortgage loan for 90% of the value. You must come up with cash for the remaining 10% The mortgage loan is a fixed rate loan at 6% interest per year using simple interest with a 30/360 formula. Problem 1 - Calculate the monthly payment of the loan. Problem 2 - Prepare...
1] Assume one wants a monthly car payment of $200.00. Assume the interest rate on 60-month car loans is 5.5%. Assume one has $2,750 to put down on the car. Given these assumptions, what is the most this person should pay for a car? 2] If one finances $257,000 for a home at 4.9% interest for 30 years, what would be the monthly payment for principal and interest?
Real Estate Finance answer all please . John Corbitt takes a fully amortizing mortgage for $80,000 at 10 percent interest for 30 years, monthly payments. What will be his monthly payment? 2. Dave Burns wants to buy a house. To do so, he must incur a mortgage. A local lender has determined that Dave can afford a monthly payment of $600, principal and interest. If the current interest rate on 30-yearm fixed-rate mortgage is 9.50 percent, what is the maximum...
Long questions Throughout this question, assume annual interest rate is 3.6% with monthly compounding. You are a loan officer in the mortgage department of a local bank. A customer, who is also a Stevens alum, walks in and applies for a $750,000 loan to buy a starter home in Hoboken. The standard terms your bank have been offering to previous customers are as followed, • Contract A: a 15-year fixed rate loan, with an annual rate of 3.6% and with...
Please post with mathematical formulas please, not an excel sheet! 1. Mr. X is repaying a loan by monthly payments of $146.75 at a nominal annual rate of 9% compounded monthly. Immediately after one of the pay- ments is made, when Mr. X has still 50 payments ahead of him, the lender lowers the interest rate to 7.8% nominal annual rate compounded monthly. Mr. X chooses to keep the same monthly payments, except the last payment that is larger than...