ACCT Assignment 1
MrJinx29
acct300_01-20.xlsEx. 1-20
| Exercise 1-20 | # Incorrect N-box and B-box entries COUNTIF(A12:Z200,"~*") | ||||||||||||||||||||||||||||
| Name: | 0 | ||||||||||||||||||||||||||||
| Section: | # N-box Incorrects due to blanks COUNTIF(A12:Z200," ") | ||||||||||||||||||||||||||||
| 19 | |||||||||||||||||||||||||||||
| Score: | 0% | # N-box +B-box corrects COUNTIF(A12:Z200," ") | |||||||||||||||||||||||||||
| Key Code: | 2 | 0 | |||||||||||||||||||||||||||
| Instructions | 19 | ||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD8-AD4-AD2)/AD8 | ||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% | ||||||||||||||||||||||||||||
| A red asterisk (*) will appear in the column to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is incorrect, returns "*" | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is correct, returns single space, " " | |||||||||||||||||||||||||||||
| WATTS INC. | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | ||||||||||||||||||||||||||||
| Statement of Cash Flows | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | ||||||||||||||||||||||||||||
| For the Month Ended July 31, 2013 | |||||||||||||||||||||||||||||
| Cash flows from operating activities: | Steps: | ||||||||||||||||||||||||||||
| Open this sheet and macro sheet | |||||||||||||||||||||||||||||
| Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||||
| Net cash flows from operating activities | Insert new header - change problem number and reformat | ||||||||||||||||||||||||||||
| Net decrease in cash | Copy these formulas (column AD) to new sheet. | ||||||||||||||||||||||||||||
| Cash flows from investing activities: | Cash received from sale of capital stock | Update to new edition numbers | |||||||||||||||||||||||||||
| Deduct cash dividends | Copy new error check formulas: | ||||||||||||||||||||||||||||
| Net increase in cash | IF(sol.!$C$5="OFF","",IF(G19=""," ",IF(AND(G19<>"",G19<>sol.!G19),"*"," "))) | ||||||||||||||||||||||||||||
| Cash flows from financing activities: | Cash received from customers | Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||
| Cash payments for expenses | IF(sol.!C5="OFF","","Score:") | ||||||||||||||||||||||||||||
| Cash payment for purchase of equipment | IF(sol.!C5="OFF","",AD10) | ||||||||||||||||||||||||||||
| Cash received from notes payable | |||||||||||||||||||||||||||||
| Net cash flows from financing activities | |||||||||||||||||||||||||||||
| July 1, 2013 cash balance | |||||||||||||||||||||||||||||
| July 31, 2013 cash balance |
List the cash inflow on this line.
Enter the cash payment as a negative amount.
List the larger of the two cash inflows on this line.
List the cash outflow on this line.
Enter this cash payment as a positive amount.
Hint: Since the company is a new startup, there would have been no beginning cash balance.
sol.
| Exercise 1-20 | # Incorrect N-box and B-box entries COUNTIF(A12:Z200,"~*") | ||||||||||||||||||||||||||||
| Name: | SOLUTION | 0 | |||||||||||||||||||||||||||
| Section: | # N-box Incorrects due to blanks COUNTIF(A12:Z200," ") | ||||||||||||||||||||||||||||
| Score: | See student sheet for student's score. | 0 | |||||||||||||||||||||||||||
| Scoring: | ON | # N-box +B-box corrects COUNTIF(A12:Z200," ") | |||||||||||||||||||||||||||
| 19 | |||||||||||||||||||||||||||||
| Instructions | 19 | ||||||||||||||||||||||||||||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD8-AD4-AD2)/AD8 | ||||||||||||||||||||||||||||
| Cells with non-gray backgrounds are protected and cannot be edited. | 100% | ||||||||||||||||||||||||||||
| A red asterisk (*) will appear in the column to the right of an incorrect answer. | Notes: | ||||||||||||||||||||||||||||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is incorrect, returns "*" | |||||||||||||||||||||||||||||
| If number-entry or blank-entry box is correct, returns single space, " " | |||||||||||||||||||||||||||||
| WATTS INC. | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | ||||||||||||||||||||||||||||
| Statement of Cash Flows | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | ||||||||||||||||||||||||||||
| For the Month Ended July 31, 2013 | |||||||||||||||||||||||||||||
| Cash flows from operating activities: | Steps: | ||||||||||||||||||||||||||||
| Cash received from customers | $ 600,000 | Open this sheet and macro sheet | |||||||||||||||||||||||||||
| Cash payments for expenses | 380,000 | Open old templated, then change color palet to this sheet's | |||||||||||||||||||||||||||
| Net cash flows from operating activities | $ 220,000 | Insert new header - change problem number and reformat | |||||||||||||||||||||||||||
| Net decrease in cash | Copy these formulas (column AD) to new sheet. | ||||||||||||||||||||||||||||
| Cash flows from investing activities: | Cash received from sale of capital stock | Update to new edition numbers | |||||||||||||||||||||||||||
| Cash payment for purchase of equipment | (95,000) | Deduct cash dividends | Copy new error check formulas: | ||||||||||||||||||||||||||
| Net increase in cash | IF(sol.!$C$5="OFF","",IF(G19=""," ",IF(AND(G19<>"",G19<>sol.!G19),"*"," "))) | ||||||||||||||||||||||||||||
| Cash flows from financing activities: | Cash received from customers | Copy Score formula from this template to new sheet. | |||||||||||||||||||||||||||
| Cash received from sale of capital stock | $ 200,000 | Cash payments for expenses | IF(sol.!C5="OFF","","Score:") | ||||||||||||||||||||||||||
| Cash received from notes payable | 75,000 | $ 275,000 | Cash payment for purchase of equipment | IF(sol.!C5="OFF","",AD10) | |||||||||||||||||||||||||
| Deduct cash dividends | 25,000 | Cash received from notes payable | |||||||||||||||||||||||||||
| Net cash flows from financing activities | 250,000 | ||||||||||||||||||||||||||||
| Net increase in cash | $ 375,000 | ||||||||||||||||||||||||||||
| July 1, 2011 cash balance | 0 | ||||||||||||||||||||||||||||
| July 31, 2011 cash balance | $ 375,000 |
List the cash inflow on this line.
List the larger of the two cash inflows on this line.
List the cash outflow on this line.
Enter this cash payment as a positive amount.
Enter the cash payment as a negative amount.
Hint: Since the company is a new startup, there would have been no beginning cash balance.
