dsci fv pv homework (1)

Martha has decided to gift her parents with a small business. She conducted some market research and settled on opening a general store for them to run. To facilitate this, she plans to get a loan of Ksh. 600,000 from a bank to be paid in four equal yearly installments. The loan attracts an interest rate of 8% per annum. Required: 1: What is the annual payment that Martha has to make every year? 2: Prepare the loan amortization schedule for Martha for the four years. 3: Assuming that Martha was required to make monthly payments for a period of  3 years what would be the monthly payment (annuity)?

Direction: Solve for the following problems involving interests. Show the solution.

If she starts now, how much does Sally need to save each month for the next 9 years to accumulate $110,000 to be able to buy her dream vacation property. Assume she will be able to get a 2.5% annual rate of return on the savings. Input your answer to the nearest dollar. Answer: Check 4

6) Susan is looking to purchase her first home five years from today. The house costs $1,550,000. She will have to make a down payment of 10% of this amount and plans to take a loan from the bank for the difference. Bank charges are approximately 15% of the loan amount. She plans to start saving from today to cover both the down payment and the bank charges. a. How much will she need to save to cover both the down payment and bank charges? b. If she currently has $195,000 in her account and will make no further deposits over the next five years, what rate of interest must she earn on this account in order to achieve the savings target calculated in part (a) above?

Gabby is planning to buy a home.  She has some money for a down payment already saved.  She sees a home she would like and calculates that she would need to borrow $210,000 from a bank for a 30-year period.  The APR is 7.2%. What will be her total interest for the 30 years?   Step 1) What is the monthly payment? Step 2) What are the total payments ($) for the entirety of the loan? Step 3) What is the total interest?

Linda decided to borrow $350,000 from a bank to buy her dream house. She approached Prosperity Bank and they offered Linda the following mortage package: interest rate of 2.45 % per year, weekly repayment, for 30 years. Required: Calculating the amount of weekly repayment Linda needs to make for the mortgage. Linda is considering two investment offers for saving up money to pay off her mortage in 10 years. Investment A offers the rate of return of 9.95% per year, compounding daily. Investment B offers the rate of return of 10% per year, compounding quarterly. Help Linda choose the better investment by calculating Effective Annual Interest Rate (EAR).

Suppose that you need $30,000 for your last year of college. You could go to a private lending institution and apply for a signature student loan; rates range from 7% to 14%. However, your Aunt Sally is willing to loan you the money from her retirement savings, with no repayment until after graduation. All she asks is that in the meantime you pay her each month the amount of interest that she would otherwise get on her savings (since she needs that to live on), which is 4%.What is your monthly payment to her, and how much interest will you pay her over the year (9 months)?(Fill in the blanks below and give your answers as whole numbers.)The amount of interest per month you would pay Aunt Sally is $__(1)__ .The total interest you will pay her over the year (9 months)is $__(2)__ .

1.You are buying your first car for $20,000 and are paying $2,000 as a down payment. You have negotiated a nominal interest rate of 12 percent and you plan to pay-off the car over five years. What is the monthly payments you must make on this loan? 2. Maryann is planning a wedding anniversary gift of a trip to Hawaii for her husband at the end of 3 years. She will have enough to pay for the trip if she invests $2,500 per year until that anniversary and plans to make her first $2,500 investment on their first anniversary. Assume her investment earns a 4 percent interest rate, how much will she have saved for their trip if the interest is compounded in each of the following ways? a.Annually b. Quarterly c. Monthly 3.Compute the current price of a bond which matures in 40 years and has a required rate of return of 10 percent, a semi-annual coupon rate of 6 percent.4. What is the semi-annual coupon bond’s nominal yield to maturity (YTM), if the years to maturity is 15 years, and sells for…

Solve the given problem. A. Mrs. Ledesma apply for a loan for the renovation of their house. She agreed to pay P10,000 quarterly for 5 years that will start at the end of 2 years. If interest rate is 6% converted quarterly, how much is her loan? a. The type of annuity illustrated in the problem is ____________. b. The regular payment is ___________. c. The total number of payments is _________. d. Period of deferral is ________. e. The interest rate per period is ___________. f. The present value of the loan is ___________. B. Your mother plans to buy you laptop for your online class. She got an offer from Abenson of monthly installment of 1,950 monthly for 1 year and a down payment of 5,500. The payment will start at the end of 3 months. How much is the cash price of the laptop if the interest rate is 3% compounded monthly. a. The type of annuity illustrated in the problem is ____________. b. The regular payment is ___________. c. The total number of payments is _________. d. Period…

How would I input this information into excel?

You decide that you need $47,000 in 3 years to make a down payment on a house. You plan to make annual fixed deposits to achieve your goal. If the interest rate is 2.5%, how much should be deposited each time? Hint use the Financial Function “PMT” to solve for the payment, and PV will be zero. You owe $25,000 to your parents. You promise to make 10 annual payments of $3,000 to settle your debt. What interest rate are your parents charging (estimated up to 2 decimal places), if you make the 10 annual payments beginning one year from now? Hint use the Financial Function “RATE”. Note if you need help use the “Help on this function” feature. This help will include an example for you to follow. You are offered an investment that will pay $14,000 per year for 17 years, beginning one year from now. If you feel that the appropriate discount rate is 3.4%, what is the investment worth to you today? Your grandparents offered you some money via the following options. Assuming an annual interest…

Suppose that you are obtaining a personal loan from your uncle in the amount of $20,000 (now) to be repaid in two years to cover some of your college expenses. If your uncle usually earns minimum 8% profit (annually) on his money, which is invested in various sources, what minimum lump-sum payment two years from now would make your uncle happy?