Hello. Please help with the excel assignment. The assignment consist of circular reference and a very long high school algebra formula. I have most the problem done. I am asking help with two of the cells.

Assignm Please do not (otherwise you will jeopardize the grading proce -rename this workbook -rename any sheets or insert/delete any sheets -insert/delete any columns in a sheet -insert/delete any rows in a sheet Read the Multiple Choice and Excel assignment(s) carefully an You have to complete every cell colored yellow For every cell colored yellow, you have to decide: Dropdown -> Every cell with a dropdown, choose the Value -> enter the appropriate numeric, date/time or Formula -> enter the appropriate formula e.g. '=A1+B Array Formula -> enter the appropriate array formula The initial due date/time for this assignment is Monday, June Cell comments: every cell you must complete has a cell comment. The cell comment has spe When you rest the pointer on the cell, the comment appears. Four items of information will 1. 2. cell value - whether the cell value will be date, logical value, number, text cell formula - simple or array the formula tokens will be provided and sorted e.g. 0 (3), 1 (2), 12 (4), H the formula operators */+-^() are not provided if a formula token is used more than once in the formula, the token cou 3. cell formatting - Excel lets you change many of the ways it displays data in a cell. Fo to the cell. You can access and modify the majority of these settings in the Format characteristics. 4. cell name - any required cell name will be indicated Excel instructions: column AA will contain any Excel instructions for a chart, conditional form Assignment Instructions Quiz: 10 he grading process): nt(s) carefully and do the following: o decide: own, choose the appropriate response from the dropdown ric, date/time or text value mula e.g. '=A1+B1' press Enter te array formula e.g. '=LINEST(A1:A12, B1:B12, True, True)' press Ctrl+Shift+Enter s Monday, June 27, 2016 --- 12:00:00 PM he cell comment has specific information for the student. When a cell has a comment, a red indicator appears in the corner ems of information will be provided to the student in the cell comment. , number, text e.g. 0 (3), 1 (2), 12 (4), H18 (4), H20 (2), H36 (2), I29 (2), I33 (2), IF, ROUNDUP formula, the token count will appear in parentheses e.g. 0 (3), H18 (4) displays data in a cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a patt settings in the Format Cells dialog box (on the Format menu, click Cells). The student is required to only set 13 commonly u chart, conditional formatting, tables, data tables, range names, pivot tables, etc. trl+Shift+Enter r appears in the corner of the cell. nt, or you can add a pattern and border only set 13 commonly used formatting You are a relatively recent hire to the Hartz & Co., a local manufacturer of plumbing supply products. You have been asked to prepare for a presentation to the company's management a condensed cash-flow statement for the months of November and December, 2013. Excel Instructions The cash balance at November 1st was $72,000. It is the company's policy to maintain a minimum cash balance of $72,000 at the end of each month. Cash receipts (from cash sales and collection of accounts receivable) are projected to be $681,700 for November and $529,000 for December. Cash disbursements (sales commissions, advertising, delivery expense, wages, utilities, etc.), prior to financing activity, are scheduled to be $655,000 in November and $565,300 in December. Borrowing, when needed, is done at the beginning of the month - in increments of $1,200. The annual interest rate on any such loans is estimated to be 14.00%. Interest on any outstanding loans is paid in cash at the end of the month. Interest on any outstanding loans is paid in cash at the end of the month. Repayments of principal (if any) are assumed to occur at the end of the month. As of November 1st, the company has a $72,000 short-term loan from the local bank. Required: Use the preceding information to prepare the cash budget for November and December. (Hint: The December 31st cash balance should be $.) Data Input: Cash balance, November 1st Minimum required cash balance Budgeted cash receipts: November December Budgeted cash disbursements: November December Interest rate on borrowings Short-term loan payable, as of November 1st Borrowings in increments of $72,000 $72,000 $681,700 $529,000 $655,000 $565,300 14.0% per year $72,000 $1,200 Solution: Cash Budget For November and December, 2013 November December Cash balance, beginning Plus: Cash receipts Total Cash Available $72,000 $681,700 $753,700 97860 $529,000 $626,860 Cash disbursements, prior to financing Plus: Minimum cash balance (given) Total Cash Needed $655,000 $72,000 $655,000 $565,300 $72,000 $637,300 Excess (deficiency of) cash, before financing effects Financing: Balance Short term loan beginning of month Short-term borrowing, beginning of the month Repayments (loan principal), end of the month Balance Short term loan end of month Interest (@14.00%), paid in cash @ end of the month Total effects of financing Ending cash balance Most of the points are on cells I39, I40 and L39, L40 $98,700 $72,000 -$10,440 72000 $72,000 72000 840 -840 840 -840 $97,860 $60,720 No additional Excel instructions No pivot tables, no tables/lists, no range names, no charts