Enter the following headings for the horizontal statements

Assignment Help Accounting Basics
Reference no: EM13933949

a. Enter the following headings for the horizontal statements model onto a blank spreadsheet.

b. Under the appropriate headings, record the effects of each of the following accounting events for the first month of operations. The first event has been recorded as an example.

(1) Acquired $6,100 from the issue of common stock. 

(2) Paid $4,400 to purchase land. 

(3) Borrowed $3,000 cash. 

(4) Provided services to customers and received $700 in cash. 

(5) Paid $300 for expenses. 

(6) Paid a $100 dividend to the stockholders. 

c. Using formulas, sum each of the quantitative columns to arrive at the end-of-month amounts reported on the financial statements. Spreadsheet Tips 

(1) Center the heading Balance Sheet across columns by entering the entire heading in cell B1. Position the cursor on B1 until a fat cross appears. Click and drag the cursor across B1Â through G1. Click on the Merge and Center icon (it is highlighted in the screen in the toolbar). 

(2) Enter arithmetic signs as headings by placing an apostrophe in front of the sign. For example, to enter the equal sign in cell D4, enter =. 

(3) Copy cells by positioning the cursor in the bottom right corner of the cell to copy from (such as cell O6) until a thin cross appears. Click and drag the cursor down through the desired locations to copy to (through cell O11). 

(4) To enter the dollar sign, choose Format, Cells, and Currency.

Reference no: EM13933949

Questions Cloud

Serious transcription error in a proposal : Frank, who is 19, is an administrative assistant who has worked for the Council for two years and earns £200 a week. He has a habit of going out for a drink with the lads every weekend, and lately he has come into work late on several Monday morni..
Enactment of the sexual offences act 2003 : 1) Phillips. Walsh and Dobson referred to the outcome of Hinks [2000] (2001) 2 A.C. 241 as "a horror". (E. Phillips, C. Walsh and P. Dobson. Law Relating to Theft (Cavendish, 2001, 43))
Mitigate and remediate cyber attack : Write about how to mitigate and remediate cyber attack. This is to be written as a technical paper, with a graph showing the rate or the growth of cyber attacks. below is the format and the marking scheme.
Floor or on low-level brackets in the lounge : Eight surround-sound speakers which had rested on the floor or on low-level brackets in the lounge. These had been described as "bringing cinema quality sound to the comfort of your own lounge".
Enter the following headings for the horizontal statements : Enter the following headings for the horizontal statements model onto a blank spreadsheet.
Contractor on a standard-form building contract : "Although not essential, it is common practice when procuring a building to appoint the contractor on a standard-form building contract."(Murdoch J and Hughes W (2008) p101).
What does the us-epa consider to be hazardous waste : Write a 1200-1500 word report on the following: What does the US-EPA consider to be hazardous waste? Are there any discrepancies in the regulations?
Finding a comprehensive treatment program for patients : Finding a comprehensive treatment program for patients suffering from insomnia when traditional psychotherapy and or medications is of no help.
Statements of cash flow different for the two businesses : Prepare an income statement, balance sheet, and statement of cash flows for each of the companies.

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd