1)

Please rate thumbs up
Show your work as much as possible below each question to get full credit (Le, you...
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel). 1. If you wish to accumulate $100,000 in 5 years, how much must you deposit today in an account that pays an...
Your employer contributes $100 a week to your retirement plan. Assume that you work for this employer for another 14 years and the applicable discount rate is 7.25%. Given these assumptions, what is this benefit worth to you today? 17. You anticipate being able to put away $1,800 at the end of each year into your 401(k) for each of the next 25 years (NOT $1,800 once but $1,800 in each year) and anticipate earning 8.5% per year on your...
8-One year from now, you deposit $300 in a savings account. You deposit $1,800 the next year. Then you wait two more years (until 4 years from now) and deposit $1,000. If your account always earns 6% annual interest and you make no withdrawals, how much will be in the account 11 years from now? 9-You deposit $5000 for 5 years at 4% annual interest. In 5 years, you add $15,000 to your account, but the rate on your account...
5. Suppose you borrowed $15,000 at a rate of 8.5% and must repay it in 5 equal installments at the end of each of the next 5 years. How much would you still owe at the end of the third year, after you have made the third payment?
1)You plan to deposit $100 in a savings account at the end of each month for the next 10 years. How much will you have in 10 years, assuming a 2% annual interest rate. 2)You wish to purchase a car that costs $22,000 today. You will put $2,000 down and borrow the remaining $20,000. The interest will be 2.00% and you will make monthly payments (end of month) over 5 years. What will your monthly payment be? I need help...
How much will be your payment if you were planning to buy a house for $175,000 with 10% down if a bank was willing to give you a 30-year loan at 4.5% interest per year compounded monthly? Payments are to be made at the end of each month. $589 $645 $798 $867 16.67 points QUESTION 2 Say you bought a house for $195,000 with 10% down, and financed it from a bank for a 30-year term at 5.00% interest...
1. You have just purchased a new house and taken a mortgage for $100,000. The interest rate is 12% compounded monthly and you will make payments for 25 years. a) Find the size of the monthly payment. b) The bank has a policy of rounding the payments up to the next cent. Find the new monthly payment and compute a new n. c) What was the balance of the loan after three periods? d) How much of your third payment was Principal? Interest? e) How much did...
Suppose you are buying your first condo for $145,000, and you will make a $15,000 down payment. You have arranged to finance the remainder $130,000 with a 30-year, monthly payment, amortized mortgage at a 6.5% nominal interest rate, with the first payment due in one month. What will your monthly payments be? What will the amount of interest on the first monthly payment be? What is the amount of principal being paid on the first monthly payment? What is the...
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).17. If you invest $17,500 per year for 17 years (all payments made at the beginning of each year), you will have accumulated...
please show your work for 19-21
Problems with a little twist (1-6% unless otherwise stated) 16. If $10000 is deposited today with annual interest rate of 6% and each month is desired to withdraw from this account $100, how many times this monthly withdrawals can be done before the money runs out? 17. If we deposit $100 a month for the next 5 years into an account and at the end of 5 years the account has accumulated $10,000 what...