provide the responses with work in Excel: A$)$ Advising Mary and Joe. Mary and Joe want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have good jobs, but neither of them has paid much attention to their finances. Mary works for an accounting firm and is now making $$85,000$ a year in her position. Joe works in technology, got his master degree right after college, and is making $$88,000$ a year. They have a total of $$10,000$ in their checking account at their bank. Mary inherited $$30,000$ from her grand$-$mother a year ago that is sitting in her savings account that does not pay any interest. Mary carries $$3,500$ on her credit card, which charges an APR of $24\%.$ Joe has a credit card that charges an APR of $22\%$ and he carries a balance of $$4,500.$ They pay the minimum payment each month on their credit cards, the amount specified on the credit card statements. They purchased a condo $4$ years ago, and have estimated they have $$70,000$ equity. They are considering selling their condo, and using the equity as a down payment to buy a larger home. They have qualified for one that has a purchase price of $$525,000.$ They have pre$-$qualified for a $5-$year term and $20$ year amortization period, with a mortgage rate of $4\mathrm{.}60\%$ compounded semi$-$annually. Mary is pregnant with their first child and they would like to set aside money for their child$$ education. They are considering two different scenarios: i$))$ How much should they set aside today to have $$90,00018$ years from now, assuming they can earn $5\mathrm{.}25\%$ per year compounded seminannually on their investment ii$)$ How much should they set aside each year for the next $18$ years starting now, to have $$90,000$ in $18$ years, assuming an interest rate of $5\mathrm{.}5\%$ compounded quarterly?provide the responses with work in Excel: A$)$ Advising Mary and Joe. Mary and Joe want advice from your financial advising firm. They have provided the following information. They graduated from university four years ago and they have good jobs, but neither of them has paid much attention to their finances. Mary works for an accounting firm and is now making $$85,000$ a year in her position. Joe works in technology, got his master degree right after college, and is making $$88,000$ a year. They have a total of $$10,000$ in their checking account at their bank. Mary inherited $$30,000$ from her grand$-$mother a year ago that is sitting in her savings account that does not pay any interest. Mary carries $$3,500$ on her credit card, which charges an APR of $24\%.$ Joe has a credit card that charges an APR of $22\%$ and he carries a balance of $$4,500.$ They pay the minimum payment each month on their credit cards, the amount specified on the credit card statements. They purchased a condo $4$ years ago, and have estimated they have $$70,000$ equity. They are considering selling their condo, and using the equity as a down payment to buy a larger home. They have qualified for one that has a purchase price of $$525,000.$ They have pre$-$qualified for a $5-$year term and $20$ year amortization period, with a mortgage rate of $4\mathrm{.}60\%$ compounded semi$-$annually. Mary is pregnant with their first child and they would like to set aside money for their child$$ education. They are considering two different scenarios: i$))$ How much should they set aside today to have $$90,00018$ years from now, assuming they can earn $5\mathrm{.}25\%$ per year compounded seminannually on their investment ii$)$ How much should they set aside each year for the next $18$ years starting now, to have $$90,000$ in $18$ years, assuming an interest rate of $5\mathrm{.}5\%$ compounded quarterly?