Creating financial statements in excel

Assignment Help Accounting Basics
Reference no: EM13137590

The following procedure is recommended when creating financial statements in Excel, in order to minimize error and make the statements easier to read when provided to others:

a. Use custom number formats

b. Make excel do as little work as possible by avoiding the use of formulas

c. Use as many fonts and colors as possible in order to separate line items and subheadings

d. Hide data you do not want others to see before distributing a worksheet

Reference no: EM13137590

Questions Cloud

Explain the cost of recharging a battery : The Cost of Recharging a Battery, A 12-V automotive storage battery is charged with a constant current of 2 amp for 24 hr.
Amount reported for operating expenses : During 2010, Burlington Company incurred operating expenses amounting to $600,000, of which $550,000 was paid in cash; the balance will be paid in January 2011. On the 2010 income statement of the company, what amount should be reported for operat..
Why does a company choose to do an ipo : Why does a company choose to do an IPO? What are some major concerns for the issuing company? Do you think choosing the right investment bank is a key to the success of the IPO?
Explain the temperature of the refrigerant : Find the Temperature of the Refrigerant, A closed vessel with a volume of 2 ft^3 contains 5 lb of Refrigerant 134a. A pressure sensor in the tank wall reads 71.39 lbf/in.^2 (gage).
Creating financial statements in excel : The following procedure is recommended when creating financial statements in Excel, in order to minimize error and make the statements easier to read when provided to others:
Which of the folllowing is least likely to uncover fraud : which of the folllowing is least likely to uncover fraud?
Discuss how differences between pooling and purchase account : Discuss how differences between pooling and purchase accounting for acquisitions affect future reported earnings if the Pierson/Drew business combination.
What proportion of tires will last less than miles : The lifetime of a certain brand of tire has a mean of 43,000 miles and a standard deviation of 6,000 miles. The lifetime distribution closely follows a normal distribution. What proportion of tires will last less than 50,000 miles?
What is the ending balance of projected benefit obligation : what is the ending balance of the projected benefit obligation.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What is the implication to the financial statements

What is an intangible asset? Should all intangible assets be subject to amortization? Explain why or why not. Why are some intangible assets not amortized? What is the implication to the financial statements?

  Diversification of investments

he bonds will be insured up to $17,000, so Jose doesn't want to invest more than that amount in bonds which will earn 4 1/2%. What will be the maximum amount of interest that Jose could learn?

  Implementing the change to equity method

Gerken Company concluded at the beginning of 2013 that the company's ownership interest in DillCo had increased to the point that it became appropriate to begin using the equity method to account for the investment.

  Describe fee-for service and activity based costing

Discus briefly the activity-based costing (ABC) and explain how ABC can differ from traditional costing approaches? Consider a health care organization with which you are familiar with and it uses ABC model.

  What is the residual income

Ruger has a profit margin of 16% based on revenues of $400,000 and an investment turnover is 2. What is the residual income when the cost of capital is 10%?

  Total present value of the investment

The net present value of the investment, excluding the intangible benefits, is -$326,237. To the nearest whole dollar how large would the annual intangible benefit have to be to make the investment in the aircraft financially attractive?

  What dollar amount of supplies will be included

The January 1 inventory of supplies in an Internal Service Fund is $9,000. The fund purchases $23,000 of supplies during the year. The December 31 inventory of supplies is $6,000. If the pricing objective of the fund is to be achieved, what dollar..

  Is company violating the accounting principle of consistency

Would the use of accelerated depreciation in the financial statements be more conservative or less conservative than the current practice of using the straight-line method? Explain.

  Determine danny and mary taxable income

Your firm has clients named Danny and Mary. They are married and have two dependent children. They also fully support Mary's mother, who lives with them and has no income.

  Prepare the entry to record bad debt expense

Instead of estimating the uncollectibles at 2% of net sales, assume that 10% of accounts receivable will prove to be uncollectible. Prepare the entry to record bad debt expense.

  Explain why the amounts for premium-discount recorded

Buckman Corporation issued bonds with a face value of $800,000 on April 1, 2008. The bonds pay interest semi-annually at a coupon rate of 10% per year and the due date of the bonds is April 1, 2014. The market rate is 8% per year.

  Effectiveness of internal control

What corporations are required to issue a report on the effectiveness of its internal control over financial (ICFR) reporting?

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