Problem #1: For Problems 1 and 2, you can use any Excel technique explored in the last two labs. Problem #1: You have taken a loan of $277,000 CAD. The nominal annual rate of interest compounded monthly on this loan is 7.89%. You can afford to pay monthly $ 2367.66 CAD. How many months it will take you to repay the loan? Your answer will be an integer value that includes the last monthly payment, which will be smaller than the rest.

Which investment will give you the higher future value in 5 years? Investment 1: You deposit $100 every month into an investment savings account that has an interest rate of 2.5% compounded daily. Investment 2: You deposit $300 every three months into an investment savings account that has an interest rate of 2.6% compounded semi-annually.

solve using the appropriate formulas show full workings and find the answer. DONT USE EXCEL TO SOLVE ANYTHING ONLY USE RELEVANT FORMULAS TO SOLVE AND SHOW ALL WORKINGS 5. You have $33,556.25 in a brokerage account, and you plan to deposit an additional $5,000 at the end of every future year until your account totals $220,000. You expect to earn 12% annually on the account. How many years will it take to reach your goal?

Calculating Loan Payments You want to buy a new sports coupe for $69,300, and the finance office at the dealership has quoted you a loan with an APR of 5.6 percent for 48 months to buy the car. What will your monthly payments be? What is the effective annual rate on this loan?

If you could solve option 5 with the formulas please   Option 5: Half the required money is taken out of an investment account that pays monthly interest at a 3% annual rate.  The rest of the money is borrowed from a bank at a 4% annual interest rate, should payback within 3 years in equal monthly payments.  Find the future value of the money taken from the investment account at the end of the shop development and periodic payments to the bank.  Calculate Cumulative interest and principal payments.

part : creating a proposal after a number of years of saving up all your pennies you have finally reached a total amount of $ 4,000. you have decided to put your money into a savings account. after an extensive amount of research, you have the following options to choose from : bank 1 offers a 5% annual interest rate compounded monthly. • bank 2 offers a annual interest rate compounded quarterly . bank 3 offers a 5% annual interest rate compounded weekly. decide which bank is the best option to open a savings account for one year. show the total amounts for each bank to justify your answer . 2. decide which bank is the best option to open a savings account for 10 years . show the total amounts for each bank to justify your answer. 3.how much money would you make from saving $ 4000 in the bank selected after 10 years?

Simple Interest: Solve for the following

You just deposited $9,500 in an investment account and will deposit $5000 more four years from now. What is the built-in functions on a spreadsheet to determine how much will be in the account 11 years from now if the rate of return is 10% per year? The built-in function is =FV (10%, 11,,9500) + FV(10%,7, ,5000) and it displays $

Please refer to the formulas in the lesson and on the following website.  Pay particular attention to the examples. Scroll to the bottom to review a table with a list of various formula arrangements that may be helpful in completing this assignment. 1) If you deposit $4,000 today in a bank account and the interest is compounded annually at 10 percent, what will be the value of this investment: a. five years from now? b. ten years from now? c. fifteen years from now? d. twenty years from now? 2) If a business manager deposits $12,000 in a savings account at the end of each year for twenty years, what will be the value of her investment: a. at a compounded rate of 12 percent? b. at a compounded rate of 18 percent? 3) The chief financial officer of a home health agency needs to determine the present value of a $60,000 investment received at the end of year 15. What is the present value if the discount rate is 5%? 4) After completing her residency, an obstetrician plans to invest $9,000…

Suppose you have a student loan of $45,000 with an APR of 12% for 20 years. Complete parts (a) through (c) below. a. What are your required monthly payments? The required monthly payment is $ (Do not round until the final answer. Then round to the nearest cent as needed.)