Short Case Study ST$4\mathrm{.}2$ on page $201$ of your textbook about a loan solicitation offer of $$2,009\mathrm{.}06,18$ equal payments of $$150$ each, etc. $(75$ pts out $200$ total available points$)$

Consider the following flyer that you just received.

$$We have good news, Eric Moon! Your credit history allows us to offer you a guaranteed check of $$2,009\mathrm{.}06.$ That$$s right$$a preapproved loan just in time to help with your vacation! It$$s easy. Just endorse the attached loan check and deposit it in your bank account. Your payment schedule will be $18$ equal monthly payments of $$150$ each, beginning $30$ days after your depositing the check in your bank account.$$

Determine the annual percentage of this loan solicitation.

What would be the finance charge $($dollar amount the credit will cost you$)?$

Suppose you have a credit card. Is it better by doing a cash advance in the amount of $$2,009\mathrm{.}06$ on your credit card? Your credit company charges APR of $24\mathrm{.}99\%$ for cash advances. Determine the annual percentage rate $($APR$)$ of this loan solicitation.

Suppose that you decided to go with a cash advance by making $$50$ monthly payment until you pay off the loan. What would be the total finance $($interest$)$ charge $($dollar amount the credit will cost you$)$ for each option?

Please ensure you are not using your textbook's international and$/$or wrong version. You will lose a huge amount of valuable points if you use the wrong numbers.$$

Please submit a single Excel file with three tabs in it $($one tab for each case study.$)$

Please show all your work clearly $($factor notations, working $($not screenshots$),$ Excel, and$/$or mathematical formulas.

The more organized your work is$,$ the more chances to get a higher score. ST$4\mathrm{.}2$ Consider the following flyer that you just received.

$"$We have good news, Eric Moon! Your credit history allows us to offer you a guaranteed check of $\backslash (\backslash$$ $2,009\mathrm{.}06\backslash ).$ That's right$-$a preapproved loan just in time to help with your vacation! It's easy. Just endorse the attached loan check and deposit it in your bank account. Your payment schedule will be $18$ equal monthly payments of $\backslash (\backslash$$ $150\backslash )$ each, beginning $30$ days after your depositing the check in your bank account."

a$.$ Determine the annual percentage of this loan solicitation.

b$.$ What would be the finance charge $($dollar amount the credit will cost you$)?$

c$.$ Suppose you have a credit card. Is it better by doing a cash advance in the amount of $\backslash (\backslash$$ $2,009\mathrm{.}06\backslash )$ on your credit card? Your credit company charges APR of $\backslash (24\mathrm{.}99\backslash \%\backslash )$ for cash advances. Determine the annual percentage rate $($APR$)$ of this loan solicitation.

d$.$ Suppose that you decided to go with a cash advance by making $\backslash (\backslash$$ $50\backslash )$ monthly payment until you pay off the loan. What would be the total finance $($interest$)$ charge $($dollar amount the credit will cost you$)$ for each option? $2.$ Short Case Study ST$4\mathrm{.}2$ on page $201$ of your textbook about a loan solicitation offer of $\backslash (\backslash$$ $2,009\mathrm{.}06,18\backslash )$ equal payments of $\backslash (\backslash$$ $150\backslash )$ each, etc. $(75$ pts out $200$ total available points$)$

$3.$ Short Case Study ST$4\mathrm{.}5$ on page $202$ of your textbook about buying a home worth of $\backslash (\backslash$$ $110,000\backslash )$ with a downpayment of $\backslash (\backslash$$ $50,000\backslash ),$ etc. $(75$ pts out $200$ total available points$)$

Please ensure you are not using your textbook's international and$/$or wrong version. You will lose a huge amount of valuable points if you use the wrong numbers.

Please submit a single Excel file with three tabs in it $($one tab for each case study.$)$

Please show all your work clearly $($factor notations, working $($not screenshots$),$ Excel, and$/$or mathematical formulas.

The more organized your work is$,$ the more chances to get a higher score.