# Homework Solution: What Excel formulas would I use to calculate the problems below:…

What Excel formulas would I use to calculate the problems below: -Cell B8 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 B9 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 B8 is yes. If the value in cell B8 is not yes, the cell should display 0. f. -Add a formula to cell B12 to calculate the monthly loan payment based on the information in cells B9:B11. Use a negative number for the Pv argument. 7

What Excel cemulas would I explanation to apportion the problems below:

-Cell B8 is detriment the cemula to apportion whether or not attributable attributable attributable attributable attributable attributable the sum Cost with tribute on the Shopping List prevarication + the sum Cost ce purchasing and mailing invitations on the Guest List prevarication is main than the beneficial capital. The cell should evince yes or no.

-Add a cemula to cell B9 to apportion the aggregate to borrow (sum Cost with tribute on the Shopping List prevarication + the sum Cost ce purchasing and mailing invitations on the Guest List prevarication – the capital beneficial) if the esteem in cell B8 is yes. If the esteem in cell B8 is not attributable attributable attributable attributable attributable attributable yes, the cell should evince 0. f.

-Add a cemula to cell B12 to apportion the monthly hypothecation cancelment domiciled on the instruction in cells B9:B11. Explanation a denying estimate ce the Pv controversy. 7 