Module $7$ Excel Spreadsheet Instructions

Below you will see three sets of inputs. After inputting all of your formulas, you should be able to use any of these sets of data and have the answers automatically update.

For this assignment, please choose one of the data sets above and input all of the necessary formulas to find the answers. Once you are done, choose a different data set, enter it into your spreadsheet, and check the updated answers to ensure that everything is flowing through the formulas appropriately. A check answer for each one has been provided.

Provide formulas please.Sales Budget

Cash Budget

Cash balance, beginning

Collections from customers:

From April sales

From May sales

From June sales

From July sales

From August sales

Total cash available

Cash disbursements:

Merchandise

Variable expenses

Fixed expenses

Interest paidForecasted Income Statement

For Quarter Ended August $31,19$X$5$

Sales

Cost of goods sold

FORMULA$17$

Gross profit

FORMULA$18$

Expenses:

Variable expenses

Fixed expenses

Depreciation expense

Interest expense

Total expenses

FORMULA$19$

FORMULA$20$

FORMULA$21$

FORIMULA$22$

Net income

$$0$

z$=$z$=$z$=$z$==$

Forecasted Balance Sheet

August $31,19$X$5$

Assets:

Cash

FORMULA$23$

Accounts receivable

FORMULA$24$

Merchandise inventory

FORMULA$25$

Fixed assets $($net$)$

FORMULA$26$

Total assets

Liabilities & equity:

Accounts payable

FORMULA$27$

Loans payable

$0$

Owner's equity

FORMULA$28$

Total liabilities & equity