Create a formula that sums the total net book values

Assignment Help Financial Accounting
Reference no: EM131335415

Assignemnt

REQUIRED

a. Download the spreadsheet for problem:

b. Create formulas to calculate the following:

• Accumulated depreciation (all assets use the straight-line method; all assets acquired any time during the year get a full year's initial depreciation)

• Current year's depreciation (straight-line method, full amount for initial year in which asset acquired)

• Ending accumulated depreciation

• Net book value at end of period

• Current year in the cell to the right of the phrase "Depreciation schedule for year"

• Column totals for acquisition cost, beginning depreciation, current depreciation, ending accumulated depreciation, net book value

• In the cell to the right of the arrow following the text "Cross-footing test," create a formula that checks whether the sum of the net book value column equals the sum of acquisition costs minus the sum of ending accumulated depreciation. If the two values match, the formula should display the text "Okay"; otherwise, it should display the text "Error."

c. Create a table at the bottom of your worksheet that consists of two columns: (1) asset name (values should be chair, desk, laptop, monitor, software, and workstation); and (2) net book value (create a formula to calculate this number), assuming that the current date is 06/30/2014. Then:

• Create a formula that sums the total net book values for all classes of assets.

• In the cell to the right of the total net book values for all asset classes, create a formula that compares the total net book values for all classes of assets to the sum of all net book values in the top portion of the spreadsheet. The formula should return "Okay" if the two totals match or "Error: Sum of net book values by asset class does not equal sum of all net book values" if the two totals do not equal one another.

d. Enter your name in row 1 in the cell to the right of the text "Name."

Attachment:- Spreadsheet_for_Problem.xlsx

Reference no: EM131335415

Questions Cloud

People from a school trip : The Jurassic Zoo charges $12for each adult admission and $2for each child. The total bill for the 259 people from a school trip was $1128. How many adults and how many children went to the zoo?
Simplex method to maximize : Use the simplex method to maximize P= 8x+9y subject to 3x+2y is less than or equal to 12 6x+1y is less than or equal to 15 X is greater than 0 Y is greater than 0
Calculate the total consumer surplus : Graph the demand, marginal cost, and external marginal cost functions. b. If marching bands do not consider the external marginal costs they impose on others, how many songs will be played?
What is the specific issue or concern being presented : One nursing theory will be presented as a framework to resolve a problem occurring within one of the professional areas of leadership, education, informatics, healthcare policy or advance clinical practice. The same nursing theory selected in Ass..
Create a formula that sums the total net book values : Create a table at the bottom of your worksheet that consists of two columns: (1) asset name. Create a formula that sums the total net book values for all classes of assets.
Specify both the type of policy and its magnitude : To achieve the socially optimal output, government can use a price-based intervention. Determine the ideal measure for government to use to achieve this goal. Specify both the type of policy and its magnitude.
Counterclockwise from the positive x-axis : Resolve the given vector into its x-component and y-component. The given angle θ is measured counterclockwise from the positive x-axis (in standard position). Magnitude 2.76 mN, θ =237.65°
Calculate the linear velocity in miles per hour : The blade on a typical table saw rotates at 3650 revolutions per minute. Calculate the linear velocity in miles per hour of one of the teeth at the edge of the 11 inch diameter blade.
What is the roller angular speed : A printing press has a roller 13 inches in diameter. The speed of a point on the roller's surface moves at 94 feet per second. What is the roller's angular speed?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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