is a Pod onsecutive years. 00 per year. Ruby e child turns 17. Ro month and would like to Ruby 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 580 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 creat, which has acredit limit of $12,000. The only payment that is being made on this line of credit on a monthly basis IN Max and Ruby have gym membership which s $100 per month in $60 per month breat . Groceries amount to $250 per month Cable TV and Internet service amounts to $120 per month Monthly cell phone bits 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. it Sultrum Bil 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 goal of saving up for their child's education. 1. C JUC ABD ars. Ruby 7. Ruby d like to 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 of $13,000. exchange including Royal Bank and Apple. These stocks have a value $1,500. Their current credit card balance which is due in 30 days from today is Together they have $4,500 in a chequing account and $2,000 in a savings account at Royal Bank. 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 goal of saving up for their child's education. is a Pod onsecutive years. 00 per year. Ruby e child turns 17. Ro month and would like to Ruby 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 580 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 creat, which has acredit limit of $12,000. The only payment that is being made on this line of credit on a monthly basis IN Max and Ruby have gym membership which s $100 per month in $60 per month breat . Groceries amount to $250 per month Cable TV and Internet service amounts to $120 per month Monthly cell phone bits 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. it Sultrum Bil 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 goal of saving up for their child's education. 1. C JUC ABD ars. Ruby 7. Ruby d like to 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 of $13,000. exchange including Royal Bank and Apple. These stocks have a value $1,500. Their current credit card balance which is due in 30 days from today is Together they have $4,500 in a chequing account and $2,000 in a savings account at Royal Bank. 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 goal of saving up for their child's education