Answered step by step
Verified Expert Solution
Link Copied!

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!

image text in transcribed

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Finesse An Accounting Guide For Entrepreneurs

Authors: TaShara Ramese

1st Edition

1732510903, 978-1732510906

More Books

Students also viewed these Accounting questions

Question

600 lb 20 0.5 ft 30 30 5 ft

Answered: 1 week ago