I need help with these questions from an expert please

by reference of the PPt

canada ppt calculation

these are all the data my apology

PART A: "ROBERT \& ANGELA" - MORTGAGE FINANCING Source Material: PPt - Calculation (How Much Can I Afford?) PPt-Mortgage Financing Question \#1 - Mortgage ratios - How much can Robert \& Angela spend on a mortgage payment? - How much of a mortgage? -What is a mortgage "stress test"? -What is the impact of the "stress test"? Mortgage Amount? Mortgage Payment? Difference? Question \#2 - Is a high ratio mortgage required? - How is the impact of a high ratio mortgage? Question \#3 - Five (5) factors creditors consider with mortgage applications and why each is important? PART B: "FRANCIS" - DEBT CONSOLIDATION STRATEGY Source Material: PPt - Personal Financial Statements PPt - Financial Statement Analysis Question \#1 - Analyze Francis' financial situation Source Material: PPt - Debt Management \& Insolvency Question \#2 Option A: Debt consolidation "installment loan" a. Compare two different financial institutions offerings b. Choose and explain your preferred option c. Estimate how much money Frances would save? d. Two (2) advantages and two (2) disadvantages? Option B: Debt consolidation "mortgage refinance" a. Compare "5-year fixed" vs "5-year variable" rates b. Choose and explain your preferred option c. Does Frances have enough equity in his condo? d. $6,000 extra funds - extended amortization? e. Three (3) recommendations for Francis + explanation? 1. The current 5 -year fixed mortgage rate is 4.1%. If the current Bank of Canada 5-year rate is 5.25%, how much would they qualify for now assuming they must pass the stress test? 2. If they spend the maximum, will they need a high ratio mortgage (GE or CMHC insurance)? 3. Explain to Robert and Angela, what creditors look for when they apply for a mortgage? 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: 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