Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need help with the question 6. I don't understand what is asking. I have provided my work and I hope I can follow
Hello, I need help with the question 6. I don't understand what is asking. I have 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. A B C D E G H M N + Equity Saltzman, Capital $9,000 4 5 6 7 8 9 10 11 12 13 14 15 10 16 17 18 19 20 21 22 23 24 25 26 27 a) b) c) d) e) ) 9 h) ) Assets Accounts Office Cash Receivable Supplies $9,000 $0 $0 (3,000) 0 0 0 0 1,980 4,500 0 0 (1,400) 0 0 (420) 420 0 4,600 0 (360) 0 (2,400) 0 0 300 0 (300) 3,000 (3,000) 0 (2000) 0 0 0 0 (600 $7,220 $1,600 $1,500 Liabilities Accounts Payable SO (3,000) 1,980 0 (1,400) 0 0 0 (360) (2,400) 0 0 0 + 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 0 4500 0 0 4.600 0 0 0 0 (2,000) (600) $15,500 k) ) m) ($5.180) Balance Verification Total assets Total liabilities and equity Difference $10,320 10,320 $0 PTRANS3 Answers Chart PTRANST Type here to search 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 Sei ($360) Ending Balance $ 9.740 45 Salaries ($2,400) Liabilities 46 Supplies ($600) Accounts Payable $ (5,180) 47 Total Expenses ($6,360) 48 Net Income $ 2,740 Owner's Equity 49 Saltzman Capital $ 15,500 50 Total Liabilities & Owner's Equity $ 10,320 51 6 52 53 54 PTRANS3 Answers Chart PTRANST Type here to search O 11
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