Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need help with a question 6. I don't understand what this question is asking about. I provided my work and I hope I
Hello, I need help with a question 6. I don't understand what this question is asking about. I provided my work and I hope I can follow along with your step by step guidance. Thank you!
WHAT-IF ANALYSIS 6. Wilson initially invested $9,000 in the business. Could he have invested less? How little could he have invested initially and never have his cash balance go below zero? To help different amounts in cell B8 to help determine an answer. When you have determined an answer this question, move to column J and analyze the information provided. Then enter answer, use the File Print command to print the range A1 to J21 all on one page. Explain below how you derived your answer. PIRANS Business Transactions + 3 4 5 6 7 8 9 10 11 12 13 14 15 16 a) b) c d) e) ) 9) h) ) Cash $9,000 (3,000) 0 4,500 (1,400) (420) 0 (360) (2,400) 300 3,000 (2.000) 0 $7,220 Assets Accounts Receivable $0 0 0 0 0 0 4,600 0 0 0 (3.000) 0 0 $1,600 Office Supplies $0 0 1,980 0 0 420 0 0 0 (300) 0 0 (600) $1,500 Liabilities Accounts Payable $0 0 1,980 0 (1,400) 0 0 0 0 0 0 0 Equity Saltzman Capital $9,000 (3,000) 0 4,500 0 0 4,600 (360) (2,400) Running Cash Balance $9,000 6,000 6,000 10,500 9,100 8,680 8,680 8,320 5,920 6,220 9,220 7,220 7,220 17 18 19 20 21 22 0 (2.000) (600) $9,740 $580 23 24 25 26 27 28 Balance Verification Total assets Total liabilities and equity Difference $10,320 10,320 $0 K> PTRANS3 Answers Chart PTRANST Ready Type here to search o ANCIL NUDE! Styles Cells N47 B D E F G H K 37 Woody's Web Services Woody's Web Services Woody's Web Services 38 Income Statement Statement of Owner's Equity Balance Sheet 39 June, 2020 For the Month - Ended June 30,2020 Assets 40 Cash $ 7,220 41 Revenue $ 9,100 Beginning Balance $ 9,000 Accounts Receivable $ 1,600 42 Expenses: Plus: Net Income $ 2,740 Office Supplies $ 1,500 43 Rent ($3,000) Less: Withdrawals $ (2000) Total Assets $ 10,320 44 Internet Sel (S360) Ending Balance $ 9,740 45 Salaries ($2.400) Liabilities 46 s Supplies ($600) Accounts Payable 580 47 Total Expenses ($6,360) 48 Net Income $ 2,740 Owner's Equity 49 Saltzman Capital $ 9,740 50 Total Liabilities & Owner's Equity $ 10,320 51 6) 52 a 53 54 55 56 57 58 PTRANS3 Answers Chart PTRANST Read WHAT-IF ANALYSIS 6. Wilson initially invested $9,000 in the business. Could he have invested less? How little could he have invested initially and never have his cash balance go below zero? To help different amounts in cell B8 to help determine an answer. When you have determined an answer this question, move to column J and analyze the information provided. Then enter answer, use the File Print command to print the range A1 to J21 all on one page. Explain below how you derived your answer. PIRANS Business Transactions + 3 4 5 6 7 8 9 10 11 12 13 14 15 16 a) b) c d) e) ) 9) h) ) Cash $9,000 (3,000) 0 4,500 (1,400) (420) 0 (360) (2,400) 300 3,000 (2.000) 0 $7,220 Assets Accounts Receivable $0 0 0 0 0 0 4,600 0 0 0 (3.000) 0 0 $1,600 Office Supplies $0 0 1,980 0 0 420 0 0 0 (300) 0 0 (600) $1,500 Liabilities Accounts Payable $0 0 1,980 0 (1,400) 0 0 0 0 0 0 0 Equity Saltzman Capital $9,000 (3,000) 0 4,500 0 0 4,600 (360) (2,400) Running Cash Balance $9,000 6,000 6,000 10,500 9,100 8,680 8,680 8,320 5,920 6,220 9,220 7,220 7,220 17 18 19 20 21 22 0 (2.000) (600) $9,740 $580 23 24 25 26 27 28 Balance Verification Total assets Total liabilities and equity Difference $10,320 10,320 $0 K> PTRANS3 Answers Chart PTRANST Ready Type here to search o ANCIL NUDE! Styles Cells N47 B D E F G H K 37 Woody's Web Services Woody's Web Services Woody's Web Services 38 Income Statement Statement of Owner's Equity Balance Sheet 39 June, 2020 For the Month - Ended June 30,2020 Assets 40 Cash $ 7,220 41 Revenue $ 9,100 Beginning Balance $ 9,000 Accounts Receivable $ 1,600 42 Expenses: Plus: Net Income $ 2,740 Office Supplies $ 1,500 43 Rent ($3,000) Less: Withdrawals $ (2000) Total Assets $ 10,320 44 Internet Sel (S360) Ending Balance $ 9,740 45 Salaries ($2.400) Liabilities 46 s Supplies ($600) Accounts Payable 580 47 Total Expenses ($6,360) 48 Net Income $ 2,740 Owner's Equity 49 Saltzman Capital $ 9,740 50 Total Liabilities & Owner's Equity $ 10,320 51 6) 52 a 53 54 55 56 57 58 PTRANS3 Answers Chart PTRANST Read
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started