User Account

All Pages

Using the data provided below you are to input formulas in

Assignment Help Accounting Basics
Reference no: EM13482298

1- Using the data provided below you are to input formulas in the area designated below to calculate: % complete, revenue to be recognized in each year, and gross profit to be recognized in each year.please note formulas used in excel to calculate.





Hint: I suggest you use formulas with an IF function regarding the gross profit section of your speadsheet because your spreadsheet should be able to calculate correct answers whether a contract generates a profit or loss.











2- Using the data given and the solutions your spreadsheet generated print out the JE Document posted and use it to prepare all journal entries for 2013. Your journal entries must be handwritten and turned in at the beginning of class the day this assignment is due.










Data: March 2,2014






Contract price 1,200,000






2012 2013 2014
Costs incurred to date** $280,000 $600,000 $785,000
Estimated costs yet to be incurred 520,000 200,000 0
Customer billings to date** 250,000 500,000 1,200,000
Collections of billings to date** 120,000 320,000 1,040,000




**Hint: You have to figure out the actual cost, billings, and collections for each respective year. The reason why is because the information presented is "to date" not "Costs expended this year" as in the handouts and some of your assigned exercises/problems.










Use the format provided below to input formulas for each respective year.





2012 2013 2014
Costs expended to date


Estimated total costs


% complete






Contract price


% complete


Revenue recognized to date


Revenue recognized prior


Revenue recognized current






Estimated total gross profit


% complete


Gross profit recognized to date


Gross profit recognized prior


Gross profit recognized current


















Reference no: EM13482298

Questions Cloud

The inventory at june 1 and costs charged to work in : the inventory at june 1 and costs charged to work in process -department 60 during june are as follows3600 units 70
I am comparing a companies liquidity between 2 years in the : i am comparing a companies liquidity between 2 years. in the year 2007 i find it has a higher current ratio a higher
Balanced scorecard is one of those management fads that : 1. balanced scorecard is one of those management fads that will disappear several years in the future. in addition
What should be the prices of the following preferred stocks : what should be the prices of the following preferred stocks ifcomparable securities yield 7 percent? why are the
Using the data provided below you are to input formulas in : 1- using the data provided below you are to input formulas in the area designated below to calculate complete revenue
Charles corp has outstanding accounts receivable totaling : charles corp. has outstanding accounts receivable totaling 6.9 million as of december 31 and sales on credit during the
Big oil inc has a preferred stock outstanding that pays a : big oil inc. has a preferred stock outstanding that pays a 9annual dividend. if investors required rate of return is 13
Before year-end adjusting entries carter companys account : before year-end adjusting entries carter companys account balances at december 31 2013 for accounts receivable and the
The simply french restaurant has identified the following : the simply french restaurant has identified the following activities performed by its staffsettables

Reviews

Write a Review

Accounting Basics Questions & Answers

  Determine cost recovery deduction of automobile

Hans purchased a new passenger automobile on August 17, 2009, for $40,000. During the year the car was used 40% for business and 60% for personal use. Determine his cost recovery deduction for the car for 2009.

  Example of earnings management

Explain how the Kellogg transactions described could be interpreted as an example of earnings management.

  You recently joined the internal auditing department of

you recently joined the internal auditing department of marcus clothing corporation. as one of your firs assignments

  Construct a bond amortization table

Construct a bond amortization table for this problem to indicate the amount of interest expense and discount amortization at each May 31. Include only the first five years. Make sure all columns and rows are properly labeled.

  Concept regarding transactions

The company can identify separately the cost of the product and services and has determined that fair value of the products and services is the selling price (VSOE). Under both US GAAP and IFRS, which of the following statements would be correct r..

  Prepare material and labor journal entries

Bliny Corporation makes a product with the following standard costs for direct material and direct labor: Prepare material and labor journal entries

  High-low method to estimate pizzeria paradise quarterly

Use the high-low method to estimate Pizzeria Paradise's quarterly cost equation (i.e., use the high-low method to estimate Pizzeria Paradise's quarterly fixed costs and variable cost per pizza?

  Contribution margin for the current and projected year

Compute (1) the contribution margin for the current and the projected year, and (2) the fixed costs for the current year. (Assume that fixed costs will remain the same in the projected year.)

  Comprehensive annual financial report briefing

Prepare an overview of government accounting for a business person, using the State of Georgia as an example. Describe the entity and evaluate the Management Discussion & Analysis (MD&A) section.

  Computing price of forward contract

What is the forward price of your contract? Suppose both the 1-year and 11-year spot rates unexpectedly shift downward by 2 percent. What is the price of a forward contract otherwise identical to yours?

  Accounting information pertaining to economic activities

Which of the following entities would not require accounting information pertaining to their economic activities?

  Annual rate of bonds

In the section on the yield to call, a bond pays annual interest of $80 and matures after ten years. The bond is valued at $1,147 if the comparable rate is 6 percent and the bond is held to maturity.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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