Case Study Frances: Frances Taylor, age 37, is single and has just returned to the work full-time as a software developer. Previously, he had reduced his work schedule to part-time so he could complete his master's degree. He thought he had enough money saved to cover his expenses while is he was in school, but he soon realized it wasn't enough. He has come to you for help to get his spending and debt under control. He also wants to discuss his mortgage as he is approaching the end of his term in 2 months. He has provided you with the following information: Net Worth Statement Cash Flow Statement Frances Taylor Frances Taylor Year Ending 20XX Year Ending 20XX Assets: Chequing Account Emergency Fund - TFSA Car Personal Possessions Condominium Total Assets Liabilities: RBC VISA $12,000 Scotiabank Mastercard $11,000 Unsecured Line of Credit $36,000 Mortgage $235,000 Total Liabilities $294,000 Net Worth: $142,000 Debts $2,000 $6,000 $16,000 $12,000 $400,000 $436,000 Balance Interest Rate 19% 19,99% $36,000 8% $235,000 4.25% $294.000 RBC Visa $12,000 Scotiabank M/C $11,000 Un. L of C Mortgage Total Monthly Payment $240 $220 $1,080 $1,450 $2.990 # Years to Repay 8.4 9.2 3.1 20.08 Cash Inflows: Gross Income Deductions (CPP, EI, Taxes) Net Income (Take home pay) Cash Outflows: Mortgage Payment Property tax Condo fees Heat Other Utilities Home insurance Auto insurance & Maintenance Gasoline Food Entertainment Clothing Other expenses/Vacation RBC Visa payment Scotiabank Mastercard payment Line of credit payment Total Expenses Deficit $92,000 $22,488 $69,512 $17,400 $2,350 $3,000 $1,000 $2,900 $1,000 $1,500 $3,600 $3,600 $6,000 $2,400 $8,000 $2,880 $2,640 $12,960 $71,230 ($1,718)

Case Study - Frances: Frances Taylor, age 37, is single and has just returned to the work full-time as a software developer. Previously, he had reduced his work schedule to part-time so he could complete his master's degree. He thought he had enough money saved to cover his expenses while is he was in school, but he soon realized it wasn't enough. He has come to you for help to get his spending and debt under control. He also wants to discuss his mortgage as he is approaching the end of his term in 2 months. He has provided vou with the following information: 1. Review Francis' current financial information and briefly comment. (No Calculations required) 2. Analyze a debt consolidation strategy using an instalment loan for Francis. a. Briefly research two financial institutions that provide Installment loans and provide the interest rate, term and any additional features. (2 marks) b. Based on your research, choose the best option for Francis and explain why. c. How much money will Francis save with this debt consolidation loan. d. List two benefits and two drawbacks for this debt consolidation. 3. Analyze a debt consolidation strategy consolidating Francis' debt into his mortgage. a. Research a financial institution that provide a 5-year fixed mortgage and a variable rate mortgage and provide the interest rate, term and additional features. b. Based on your research, choose the best option for Francis and explain why. c. Does Francis have enough equity in his condo to do a mortgage consolidate? Why or why not? d. Francis would like to be able to cover his cash flow deficit and to have an additional $6,000 to put towards savings and other goals. Can he leave his amortization the same or will he need to extend his amortization? If yes, by how many years. e. What three recommendations would you make to Francis, including 2 benefits and drawbacks for each