

Payments of $250, $500 and $600 are due at the ends of years 1, 3 and...
3. A student pays 87.50 per quarter for insurance. What would the pay- ments be if they were made annually? Monthly? Weekly? Every two years? Annual interest is 18% compounded monthly. 4. A bank customer deposits $100 at the end of every quarter for 5 years. He then increases the deposit to $120 and continues to make quarterly payments for 6 more years. Assuming an effective rate of 8% per annum, how much is in account after 5 years? After...
A Debt of $600 aue in three years and $800 due in four years is to be repaid by a single payment two years from now.if the interest rate is 8 % com pounded semiannually, now much is the payment?
A 7-year annuity has annual payments of $2,500. The first payment is at the end of year 1. If interest is 5 percent per annum (effective annual rate) for 2 years followed by 6 percent per annum (effective annual rate) for 5 years, what is the future value of this annuity at the end of 7 years? Please don't answer using excel.
3. A $300,000 home loan is amortized by equal monthly payments for 25 years, starting one month from the time of the loan at a nominal rate of 7% convertible monthly. a. Find the monthly payment amount. b. Find the outstanding balance when 10 years of payments remain. c. Find the total interest paid during the last 10 years of the loan? 4. Eddie is repaying a 20-year loan of 10,000 with payments at the end of each year. Each...
You were expecting debt payments of $600 due 5 months ago and $400 in 3 months from now. What single payment would you accept today for full repayment with interest allowed at 10%. if the focal point is today?
3. Find the present value of an annuity-due with payments of $1,800 every 6 months for 8 years at a nominal rate of interest of 5% per annum compounded semian- nually. Answer: $24,086.48
1. Jon invests $300 at time 8 years, $600 at time 9 years, $900 at time 10 years, and so on, up to the last payment at time 20 years. What is the accumulated value of these payments at time 25 years using an annual effective interest rate of 5%? A. $33,591.79 B. $42,872.58 C. $ 45,016.21 D.$ 46,090.56 None of the above E.
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...
1. Narelle borrows $600,000 on a 25-year property loan at 4 percent per annum compounding monthly. The loan provides for interest-only payments for 5 years and then reverts to principal and interest repayments sufficient to repay the loan within the original 25-year period. Assume rates do not change. a) Calculate the monthly repayment for the first 5 years. (CLUE: it is INTEREST ONLY) (2 marks) b) Calculate the new monthly repayment after 5 years assuming the interest rate does not...
No need for excel handwritten answers will be enough
EXCEL Question 3 (Annuity with decreasing payments) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of an annuity which is payable in arrears for 25 years. The first payment is $15,000, and the amount of each subsequent payment decreases by $250 each year. On the basis of an interest rate of 6% per annum, find the Single Premium $P that the Life Insurance Company needs to charge the policyholder for...