Alignment Font Clipboard fix C D E F G PROPRIETORSHIP FINANCIAL STATEMENTS PFS 4 Excel Applications for Accounting Principles: Website Alternative Problem By Gaylord N. Smith 5 6 The ledger of Skitch Company showed the following balances after adjustment 7 June 30, 2012, the end of the current fiscal year 8 9 Accounts payable $ 55,600 General expenses $112,350 10 Accounts receivable 103,890 Interest expense 6,750 11 Accumulated depreciation- Notes payable 46,335 12 equipment 26.250 Prepaid insurance 10, 125 13 Advertising expense138 750 B. Skitch, Capital 300,000 Salaries expense 621,450 14 Cash 80,370 Sales 943,500 15 16 Equipment 280,000 Withdrawals 18,000 17 The president of Shaheen Co. has asked you to develop a financial statement 18 worksheet (file name PES) that includes a single-step income statement a 19 statement of owner's equity, and a balance sheet. This worksheet will allow the 20 financial statements to be prepared quickly by entering account balances in the 21 appropriate cells on the worksheet. Use the information above as input for your 22 worksheet 23 24 Review the Model Building Problems Checklist on page 154 to ensure that your 25 worksheet is complete. Print the worksheet when done. Check figure. Total 26 assets, $448,135 27 28 e Go to the Customer & Sales navigation center. What percent of Bellwether's receivables are current (0-30 days old)? Round your answer to one decimal place. DO NOT use a percent sign. QUESTION 5 The Customer Sales History' report shows us how much Sales Cost of Sales and Gross profit we made from each Customer Go to Reports & Forms, click on the Accounts Receivable section (if necessary) then double click on the "Customer Sales History report. It au Current period which should be March 2019. (If it's not, click on the Options button in the toolbar, then set your dates in the top left) Using this report, what Gross Margin did Bellwether earn from sales to Franklin Botanical Gardens in March? Note- the answer is in NOT USA a percent sign in your answer. Enter with 2 decimal points Click Save and submit to see and submit Score CP hp Manager. The Collection The Total agrees with the Customer Ledgers to Collection Manager's Total Bracket windows days, the customer name, the reference (Rel) transaction date, the due date, the total amou was sent. 4. Scroll down the window to highlight the