Using the given account information, complete the balance sheet. Copy the template into the answer area and fill in the blanks with * to receive credit. Account Balance Accounts Payable $12,000.00 Advertising Expense $27,000.00 Cash $70,000.00 Common Stock $85,000.00 Dividends $8,000.00 Equipment $120,000.00 Interest Expense $600.00 Interest Payable $18,500.00 Inventory $55,000.00 Notes Payable $60,000.00 Rent Expense $5,000.00 Retained Earnings $4,600.00 Salaries Expense $2,000.00 Salaries Payable $4,500.00 Sales Revenue $95,000.00 Supplies $20,000.00 Unearned Revenue $34,000.00 Utilities Expense $6,000.00

Using the given account information, complete the balance sheet. Copy the template into the answer area and fill in the blanks with * to receive credit. Account Balance Accounts Payable $12,000.00 Advertising Expense $27,000.00 Cash $70,000.00 Common Stock $85,000.00 Dividends $8,000.00 Equipment $120,000.00 Interest Expense $600.00 Interest Payable $18,500.00 Inventory $55,000.00 Notes Payable $60,000.00 Rent Expense $5,000.00 Retained Earnings $4,600.00 Salaries Expense $2,000.00 Salaries Payable $4,500.00 Sales Revenue $95,000.00 Supplies $20,000.00 Unearned Revenue $34,000.00 Utilities Expense $6,000.00

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter22: Master Budget (master)

Section: Chapter Questions

Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...

See similar textbooks

Similar questions

The accounts receivable account has a debit balance of $214,000 and the allowance for uncollectible accounts has a credit balance of $8,000. What is the "net accounts receivable (net realizable value)" that will be shown on the balance sheet? Fill in the blank with your calculated number. DO NOT include commas, $ signs, period, decimal points, etc., just enter the raw number. Webcourses will add commas to your answer automatically. For example, if you calculated the answer to be $24,123, you would only input: 24123 ASUS f4 f5 f7 f8 f6 [X f9 f10 f11 4. 6 7 8 9. Y U 5 图 %24
Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas where indicated on the worksheet. Check to be sure that your balance sheet balances. Enter your name in cell A1. Save the completed file as MASTER2. Print the worksheet when done. Also print your formulas using fit-to-1 page scaling. Check figures: Borrowing (cell B78), $7,280; forecasted net income (cell D95), $40,200; total assets (cell D105), $507,600.
engageNOWv2 | Online teachir X * CengageNOWv2| Online teachir x .com/ilrm/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogre. * A eBook Show Me How Accounts Receivable Analysis A company reports the following: Sales $671,600 Average accounts receivable (net) 67,160 Determine (a) the accounts receivable turnover and (b) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. a. Accounts receivable turnover b. Number of days' sales in receivables days Previous Next Check My Work 11:16 AM 67°F Sunny A O E D a ) 12/3/2021 n sc hone backsoce
us Kimmel, tinancial Accounting, Be US eo 1 Srstom Announcements CALCATO Brief Exercise 8-10 Piet ts first vear of operations, Pronghorn Corp had credit sales of $2,714,100, of which $429,000 remained uncollected at year-end. The credit manager estimates that $16,370 of these recevahles w be Prepare the journal entry to record the estimated uncollectibles. (Assume an unadjusted balance of zero in Allowance for Doubtful Accounts.) (Credit account titles are automatically indented whee ment c indent manually.) Account Titles and Explanation Debit Credit SHOW LIST OF ACCOUNTS LINK TO TEXT LINK TO TEXT INTERACTIVE TUTORIAL INTERACTIVE TUTORIAL Prepare the current assets section of the balance sheet for Pronghorn Corp, assuming that in addition to the receivables it has cash of $85,320, merchandise inventory of $163,960, and supplies of $13,290. (List current a arder of liquidity) Pronghorn Corp Balance Sheet (partial) wT O secouNTS
Saved e Quiz: Accounting for Current Liabi... A Required information Knowledge Check 01 The records of Pippins, Incorporated, included the following information: Net sales 475,000 Gross margin Interest expense Income tax expense Net income 000'0 000'0 Compute the times interest earned ratio, rounded to the nearest decimal. O 4.8 O 6.4 O7.4 O 20.0 *********** II F3 F5 F6 F8 F4 #3
You have a checking account and a savings account at a credit union. Your checking account has a constant balance of $500. The table shows the total balance of the accounts over time. Total Year, t balance $2500 1 $2540 2 $2580.80 $2622.42 4 $2664.86 $2708.16 a. Write a function m that represents the balance of your savings account after t years. m(t) b. Write a function B that represents the total balance of the two accounts after t years. B(t) =
In the balance sheet, accounts Receivable, where did you get 489,555 from?
If Accounts Payable has debit postings of P170,000 credit postings of P140,000 and a normal ending balance of P60,000 which of the following was its beginning balance? Group of answer choices P30,000 Cr. P30,000 Dr. P90,000 Dr. P90,000 Cr.
Prepare the suitable accounts and find out the missing figure if any.Opening balance of debtors ..14,00,000Opening balance of bills receivable.................. 7,00,000Closing balance of bills receivable............... 3,50,000Cheque dishonoured....... 27,000Cash received from debtors............................ 10,75,000Cheque received and deposited in the bank............ 8,25,000Discount allowed............. 37,500Irrecoverable amount......... 17,500Returns inwards....... 28,000Bills receivable received from customers........ 1,05,000Bills receivable matured....... 2,80,000Bills discounted.......... 65,000Bills endorsed to creditors...... 70,000
Use this table for calculations: Minimum Days Maximum days % uncollectible 1 30 1.5% 31 60 3.5% 61 90 12% 91 365 70% I need to calculate the number of days each receivable is outstanding look at image to fill in , show work when calculating or using formulas , included all work please. After that fill in the schedule accounts recievable shown in the other image for context. When filling in the schedule of accounts recievable show what the formulas w you use and all work.
Calculate the credit given for the partial payment and the net amount due on the invoice (in $). (Round your answers to the nearest cent.) Amount ofInvoice Terms ofSale PartialPayment Credit forPartial Payment NetAmount Due $8,303.00 2/10, n/30 $2,400 $ $
Complete the following: Note: Do not round intermediate calculations. Round your final answers to the nearest cent. Amount of invoice Terms Invoice date Actual partial payment made Date of partial payment Amount of payment to be credited Balance outstanding $ 600 4/10, n/60 7/5 $ 400 7/14 $ 400.00 $ 400.00