See the picture below. I know my answer is right but the mathematical formula is wrong. THIS PROBLEM REQUIRES THE CORRECT MATHEMATICAL FORMULA AND CELL REFERENCING. DON'T FORGET TO INCLUDE THOSE TWO ITEMS IN THE ANSWER!!!!! Formatting as Table StylesE Format vFilterSelect111fx =(D8+D12)-D11A BCDGHKLM1 Formula: Add, Subtract; Cell Referencing23 Using Excel to Determine the Adjusted Cash BalanceStudent Work AreaPROBLEMFor the month of August, Pratt Company has the following information4Required: Provide input into cells shaded in yellow in this template.5Use mathematical formulas with cell references to the Problem6 concerning its checking account at its bank.area.7$ 9,500Cash balance per books, August 31Outstanding checks89%24800Determine the adjusted cash balance per books at August 3110Data from the bank statementIncorrectAdjusted cash balance per booksCharge for printing Pratt Company checksInterest earned on checking account balance11359,50540Feedback: Use a mathematical formula with cell references to the Problem area to calculatethe adjusted cash balance per books.121314Formula: Add, Subtract; Cell reference.Input a mathematical formula with a cell reference to the Problem area.1516171819

Adusted cash book is prepared to find the discrepancy in the transactions which may happen during…

Using Excel to Determine the Adjusted Cash Balance PROBLEM For the month of August, Pratt Company has the following information concerning its checking account at its bank. $ 9,500 $ 800 Cash balance per books, August 31 Outstanding checks Data from the bank statement Charge for printing Pratt Company checks Interest earned on checking account balance 35 40

Using Excel to Determine the Adjusted Cash Balance PROBLEM For the month of August, Pratt Company has the following information concerning its checking account at its bank. $ 9,500 $ 800 Cash balance per books, August 31 Outstanding checks Data from the bank statement Charge for printing Pratt Company checks Interest earned on checking account balance 35 40

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter1: Business Transactions (ptrans)

Section: Chapter Questions

Problem 7R

See similar textbooks

Similar questions

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.
Question Content Area Cash and accounts receivable for Adams Company are provided below: Current Year PriorYear Cash $76,835 $63,500 Accounts receivable (net) 48,794 78,700 Based on this information, what is the amount and percentage of increase or decrease that would be shown with horizontal analysis? Enter a decrease using a minus sign before the amount and the percentage. Account Dollar Change Percent Change Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
Question Content Area Cash and accounts receivable for Adams Company are as follows: Current Year Prior Year Cash $63,104 $54,400 Accounts receivable (net) 34,736 66,800 What are the amounts and percentages of increase or decrease that would be shown with horizontal analysis? Account Dollar Change Percent Change Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
1. Compute the current assets.Cash Php 25,867.00Barney’s drawing 50,485.00Accounts Payable 78,584.00Notes Receivable 45,051.00Building 1,500,125.00Inventory 33,669.002. Compute the Net Income.Service Income Php 356,867.00Prepaid Rent 16,800.00Interest Expense 1,523.00Barney’s drawing 21,786.00Taxes 4,544.00Utilities Expense 3,651.003. The liabilities of Bb Barn are equal to 1/3 of thetotal assets. The owner's equity is P 6,300,500. Whatis the amount of the liabilities?4. Prepare journal entries to the following transactionsfor the year 2020.Sept. 1 V Barney invested Php 150,000 in Barney repair ShopSept 3 Purchased equipment worth Php 80,000 on account.Sept. 12 Paid Php 25, 000 for the equipmentpurchased dated Sept. 3, 2020.Sept. 15 Rendered service amounting toPhp 45,000.Sept. 17 Paid salaries to employees, Php16,000
T-Account Formulas Please provide the formulas (Typed out and not in an Excel Sheet) and answers to the following problems. DEBIT SIDE OF T-ACCOUNTS 1) Find Beginning Balance CASH Debit Side 1/1 Beginning Balance UNKNOWN 1/3 Transaction A 2,500 1/15 Transaction B 4,000 1/28 Transaction E 3,400 Ending Balance 9,800 Credit Side 1/16 Transaction C 4,500 1/20 Transaction D 2,200 1/29 Transaction F 3,500 Problem 2) Find Ending Balance INVENTORY Debit Side 4/1 Beginning Balance 40,000 4/15 Transaction B 5,000 Ending Balance UNKNOWN Credit Side 4/9 Transaction A 8,000 4/28 Transaction C 25,000 SELLING EXPENSE Problem 3) Find Credit Amount Debit Side Beginning Balance 0 1/5 Transaction A 1,500 1/13 Transaction B 6,000 1/28 Transaction C 8,700 Ending Balance 14,700 Credit Side 1/9 Transaction D UNKNOWN INTEREST EXPENSE Problem 4) Find Debit Amount Debit Side 8/1 Beginning Balance 800 8/7 Transaction A UNKNOWN8/14 Transaction B 500 Ending Balance 1,800 Credit Side No…
Required information Skip to question [The following information applies to the questions displayed below.] Current Year Prior Year Cash $ 7,440 $ 8,000 Accounts receivable 54,000 18,000 Equipment, net 44,000 40,000 Land 91,680 66,000 Total assets $ 197,120 $ 132,000 Express the items in common-size percents. (Round your percentage answers to one decimal place.) Required information Skip to question [The following information applies to the questions displayed below.] Current Year Prior Year Cash $ 7,440 $ 8,000 Accounts receivable 54,000 18,000 Equipment, net 44,000 40,000 Land 91,680 66,000 Total assets $ 197,120 $ 132,000 Express the items in common-size percents. (Round your percentage answers to one decimal place.)
First hint: The Cash column should equal $49,910, A/R $900, Supplies $800, Equipment $5200 (these are all under Assets and the balance along the bottom should equal these amounts) 2nd hint: A/P column should be $5200 3rd hint: $9000 wasn't on account....so that means it is cash. Net income=10610 Read the headings. Assets = Liabilities + Owners Equity If you run stuck, please ask. Again, do not wait until the last minute to work on this assignment. Title: Accounting Finance Exercise As an accountant, your new client Michael Suze needs assistance in setting up his books for his business. To do this successfully, you start by showing him how you perform a transaction analysis based on the accounting equation of Assets = Liabilities + Owner’s Equity. You explain to Michael how to show increases and decreases in assets, liabilities and owner’s equity accounts using the analysis template. To help Michael understand transaction analysis, you reconcile each side of the equation by…
CASH A/C DATE PARTICULARS AMT. DATE PARTICULARS AMT. 1.1.2015 10000 2.1.2015 5000 7.1.2015 4000 4.1.2015 1500 15.1.2015 1500 31.1.2015 Balance C/D ? Complete the balancing of the above ledger of CASH Account and choose the correct balance answer on Feb 1. Select one: a. Credit balance 10000 b. Debit balance 14000 c. Credit balance 19000 d. Debit Balance 8000 e. Debit balance 6000 f. Credit Balance 9000
Question Content Area Cash and accounts receivable for Adams Company are as follows: Line Item Description Current Year Prior Year Cash $51,246 $43,800 Accounts receivable (net) 17,596 33,200 What is the amount and percentage of increase or decrease that would be shown with horizontal analysis? Enter a decrease using a minus sign before the amount and the percentage. Account Dollar Change Percent Change Effect Cash $fill in the blank 1 fill in the blank 2 % Accounts Receivable $fill in the blank 4 fill in the blank 5 %
3. The following was the trial balance extract from ABC Trading as at 31 March 2019.Particulars DEBIT (RM) CREDIT (RM)Purchases and Sales 22,800 41,000Inventory on 1 April 2018 5,100Capital 8,170Bank overdraft 4,300Cash 140Discount allowed and received 1,440Returns inwards and outwards 790Carriage outwards 2,180Office expenses 450Fixtures and fittings 1,210Delivery van 2,000Accounts receivables and account payables 11,900 6,720Rent and insurance 1,790Drawings 2,850Wages and salaries 8,980TOTAL 61,690 61,690Additional information as at 31 March 2019:a. Inventory on 31 March 2019 was RM4,250b. Wages and salaries accrued as at 31 march 2019 was RM210; outstanding office expenses was RM30c. Rent and insurance prepaid was RM150Required:i. Prepare the Statement of Profit or Loss and Other Comprehensive Income for the year ended 31 March 2019ii. Prepare Statement of Financial Position as at 31 March 2019
Comprehensive/Spreadsheet Problem 16-15 FORECASTING FINANCIAL STATEMENTS Use a spreadsheet model to forecast the financial statements in Problems 16-13 and 16-14. 16-13 ADDITIONAL FUNDS NEEDED Morrissey Technologies Inc.'s 2014 financial statements arc shown here. Morrissey Technologies Inc.: Balance Sheet as of December 31, 2014 Morrissey Technologies Inc.: Income Statement for December 31, 2014 Sales 3.600.000 Operating costs including depreciation 3,279,720 E81T 320.280 Interest 20.280 EST 300.000 Taxes (40%} 120,000 Net Income 180.000 Per Share Data: Common stock price 45.00 Earnings per share (EPS) 1.80 Dividends per share (DPS) 1.08 Suppose that in 2015, sales increase by 10% over 2014 sales. 1hc firm currently has 100,000 shares outstanding. It expects to maintain its 2014 dividend payout ratio and believes that its assets should grow at the same rate as sales. The firm has no excess capacity. However, the firm would Like to reduce its Operating costs/Sales ratio to 87.5% and increase its total liabilities-to-assets ratio to 30%. (It believes its liabilities to-assets ratio currently is too low relative to the industry average.) The firm will raise JOO/o of the 2015 forecasted interest bearing debt as notes payable, and it will issue long-term bonds for the remainder. the firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 12.5%. Assume that any common stock issuances or repurchases can be made at the firm's current stock price of S45. a. Construct the forecasted financial statements assuming that these changes are made. What are the firm's forecasted notes payable and long-term debt balances? What is the forecasted addition to retained earnings? b. If the profit margin remains at S'/o and the dividend payout ratio remains at 60%, at what growth rate in sales will the additional financing requirements be exactly zero? In other words, what is the firm's sustainable growth rate? (Hint: Set AFN equal to zero and solve for g.) 16-14 EXCESS CAPACITY Krogh Lumber's 2014 financial statements are shown here. Krogh Lumber: Balance Sheet as of December 31, 2014 (Thousands of Dollars) Krogh Lumber: Income Statement for December 31, 2014 (Thousands of Dollars) Sales 36,000 Operating costs including depredation 30,783 Earnings before interest and taxes 5,217 Interest 1,017 Earnings before taxes 4,200 Taxes (40%) 1680 Net income 2.520 Dividends (60%} 1,512 Addition to retained earnings 1,008 a. Assume that the company was operating at full capacity in 2014 with regard to all items except fixed assets; fixed assets in 2014 were being utilized to only 75% of capacity. By what percentage could 2015 sales increase over 2014 sales without the need for an increase in fixed assets? b. Now suppose 2015 sales increase by 25% over 2014 sales. Assume that Krogh cannot sell any fixed assets. AU assets other than fixed assets will grow at the same rate as sales; however, after reviewing industry averages, the firm would like to reduce its operating costs/sales ratio to 82% and increase its total liabilities-to-assets ratio to 42%. The firm will maintain its 60% dividend payout ratio, and it currently has 1 million shares outstanding. The firm plans to raise 35% of its 2015 forecasted interest-bearing debt as notes payable, and it will issue bonds for tile remainder. The firm forecasts that its before-tax cost of debt (which includes both short-term and long-term debt) is 11%. Any stock issuances or repurchases will be made at the firm's current stock price of 40. Develop Krogh's projected financial statements like those shown in Table 16.2 What are the balances of notes payable, bonds, common stock, and retained earnings?
Allowance method Using transactions listed in £6-S. indicate the effects of each transaction on the liquidity metric days’ sales in receivables and profiability metric return on sales.