Module 9 ule 9 Exploring Financial Tools and Functions | Excel EX 547 Session 9.1 Quick Check 1. Explain the difference between positive and negative cash flow. If you borrow 2. What is the formula to calculate how much a savings account would be worth $20,000 from a bank, is that a positive or negative cash flowt Justify your answer. if the initial balance is $1000 with monthly deposits of $75 for 10 years at 4.3 percent annual interest compounded monthly? What is the formula result? 3. You want a savings account to grow from $1,000 to $5,000 within two years. Assume the bank provides a 3.2 percent annual interest rate compounded monthly. What is the formula to calculate how much you must deposit each month to meet your savings goal? What is the formula result? 4. You want to take out a loan for $250,000 at 4.8 percent interest compounded monthly. If you can afford to make monthly payments of only $1,500 on the loan, what is the formula to calculate the number of months required to repay the loan completely? What is the formula result? 5. Rerun your calculations from Question 4 assuming that you can afford only a 6. You take out a 10-year loan for $250,000 at 5.3 percent interest compounded 7. For the loan conditions specified in Question 6, provide formulas to calculate $1,000 monthly payment. What are the revised formula and resulting value? How do you explain the result? monthly. What is the formula to calculate the monthly payment and the resulting value? the amount of the first payment used for interest and the amount of the first payment used to repay the principal. What are the resulting values? calculate how much interest you will pay in the first year and how much you will repay toward the principal? What are the resulting values? 8. For the loan conditions specified in Question 6, what are the formulas to 9. For the loan conditions in Question 6, calculate the total cost of the loan in terms of the total interest paid through the 10 years of the loan