expand icon
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
book Excel Applications for Accounting Principles 4th Edition by Gaylord Smith cover

Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Edition 4ISBN: 978-1111581565
Exercise 2
WHAT-IF ANALYSIS
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 answer this question, move to column J and analyze the information provided. Then enter different amounts in cell B8 to help determine an answer. When you have determined an answer, use the File Print command to print the range A1 to J21 all on one page. Explain below how you derived your answer.
Explanation
Verified
like image
like image
An amount $9,000 was invested at the time of establishment of business. Worksheet's beginning balance can be manipulated and it can be determined that the business owner could have invested a minimum of $3,100 initially and will never let his cash flow to drop below zero.
An amount $9,000 was invested at the time of establishment of business. Worksheet's beginning balance can be manipulated and it can be determined that the business owner could have invested a minimum of $3,100 initially and will never let his cash flow to drop below zero.
close menu
Excel Applications for Accounting Principles 4th Edition by Gaylord Smith
cross icon