AutoSave

Party Financing

As of $=$DATEVALUE$("=$TODAY"$)$

# of Invitations

# of Guests

Cash Available for Event $2500$

Do We Need to Borrow?

Amount to Borrow

APR $0\mathrm{.}049$

# Months to Pay $12$

Monthly Payment Amount

IN THIS EXCEL SPREADSHEET IN ORDER TO COMPLETE THE TASKS BELOW, WHAT FORMULAS DO I NEED?

HELP!!!

On the Summary sheet, you will be entering all the formulas. Cells to complete are filled with the light purple color. Hint: Use error checking as needed and$/$or display the formulas on$-$screen for easy viewing.

Cell B$2$ should use a function that will update the date to the current date every time the workbook is opened.

Cell B$4$ references a named range that doesn$$t exist. It should reference cell A$4$ on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.

Cell B$5$ references a named range that doesn$$t exist. It should reference cell A$3$ on the Guest List sheet. You can create the named range or edit the formula to reference the cell instead.

Cell B$8$ is missing the formula to calculate whether or not the total Cost with tax on the Shopping List sheet $+$ the total Cost for purchasing and mailing invitations on the Guest List sheet is greater than the available cash. The cell should display yes or no$.$

Add a formula to cell B$9$ to calculate the amount to borrow $($total Cost with tax on the Shopping List sheet $+$ the total Cost for purchasing and mailing invitations on the Guest List sheet $$ the cash available$)$ if the value in cell B$8$ is yes. If the value in cell B$8$ is not yes, the cell should display $0.$

Add a formula to cell B$12$ to calculate the monthly loan payment based on the information in cells B$9$:B$11.$ Use a negative number for the Pv argument.

Save and close the workbook.