Budgeting Below is the monthly financial information for Ruby and Max: Disposable income for the couple amounts to $8,000 per month. Max and Ruby just purchased a new house for $850,000. Their first monthly payment will take place this month. They were able to make a down payment equal to 25 percent of the value of the house, and the balance was mortgaged. The interest rate quoted by the bank was 3.5 percent compounded semi-annually. The mortgage has a 25-year amortization period and a five-year term, Max and Ruby share one car between the two of them. They have a car payment each month amounting to $400. Car insurance is $175 per month. Gas is roughly $80 per week. The remaining loan on the car is $7,000. The car has a fair market value of $12,000. Max and Ruby owe $5,000 on their line of credit, which has a credit limit of $12,000. The only payment that is being made on this line of credit on a monthly basis is the interest of $60 per month. Max and Ruby have gym memberships which costs $100 per month in total. . Groceries amount to $250 per month. Cable TV and Internet service amounts to $120 per month. Monthly cell phone bills amount to $140. Max and Ruby spend $500 per month on entertainment. . They have investments in several public companies on the stock exchange including Royal Bank and Apple. These stocks have a value of $13,000 . Their current credit card balance which is due in 30 days from today is $1,500, Together they have $4,500 in a chequing account and $2,000 in a savings account at Royal Bank V 0 Malings Review View Help Inable liding Required: 1. Create a monthly cash flow for Max and Ruby. You must calculate the monthly mortgage payment based on the information provided. 2. Prepare a personal balance sheet for Max and Ruby and calculate their net worth.. 3. Calculate and comment on Max and Ruby's current ratio and liquidity ratio. 4. Evaluate whether or not Max and Ruby will be capable of attaining their financial for their child's education. goal of saving up 0 R 9 PS Alt- e D F B Budgeting Below is the monthly financial information for Ruby and Max: Disposable income for the couple amounts to $8,000 per month. Max and Ruby just purchased a new house for $850,000. Their first monthly payment will take place this month. They were able to make a down payment equal to 25 percent of the value of the house, and the balance was mortgaged. The interest rate quoted by the bank was 3.5 percent compounded semi-annually. The mortgage has a 25-year amortization period and a five-year term, Max and Ruby share one car between the two of them. They have a car payment each month amounting to $400. Car insurance is $175 per month. Gas is roughly $80 per week. The remaining loan on the car is $7,000. The car has a fair market value of $12,000. Max and Ruby owe $5,000 on their line of credit, which has a credit limit of $12,000. The only payment that is being made on this line of credit on a monthly basis is the interest of $60 per month. Max and Ruby have gym memberships which costs $100 per month in total. . Groceries amount to $250 per month. Cable TV and Internet service amounts to $120 per month. Monthly cell phone bills amount to $140. Max and Ruby spend $500 per month on entertainment. . They have investments in several public companies on the stock exchange including Royal Bank and Apple. These stocks have a value of $13,000 . Their current credit card balance which is due in 30 days from today is $1,500, Together they have $4,500 in a chequing account and $2,000 in a savings account at Royal Bank V 0 Malings Review View Help Inable liding Required: 1. Create a monthly cash flow for Max and Ruby. You must calculate the monthly mortgage payment based on the information provided. 2. Prepare a personal balance sheet for Max and Ruby and calculate their net worth.. 3. Calculate and comment on Max and Ruby's current ratio and liquidity ratio. 4. Evaluate whether or not Max and Ruby will be capable of attaining their financial for their child's education. goal of saving up 0 R 9 PS Alt- e D F B