Questions
Excel Assignment (Percentage-of-completion) Required: 1- Using the data provided below you are to input formulas in...

Excel Assignment (Percentage-of-completion)
Required:
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. (10 points)
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, prepare all journal entries for 2017. Whevenver possible, the amounts for your journal entries should be formulas that reference the appropriate cells in the calcuations below. (10 points)
3-Once you have completed the spreadsheet save your file with your last name(s) and first name(s) and upload it under Assignments by the assignment due date.
Data:
Contract price 1,200,000
2016 2017 2018
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 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.
2016 2017 2018
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

In: Accounting

Analyzing and Reporting Receivable Transactions and Uncollectible Accounts Using Percentage- of-Sales Method to Estimate Bad Debt...

Analyzing and Reporting Receivable Transactions and Uncollectible Accounts Using Percentage- of-Sales Method to Estimate Bad Debt Expense

At the beginning of the year, Penman Company had the following account balances.

Accounts receivable...................... $356,000

Allowance for uncollectible accounts......... 21,400

During the year, Penman’s credit sales were $2,008,000, and collections on accounts receivable were $1,963,000. The following additional transactions occurred during the year.

Feb. 17 Wrote off Bava’s account, $8,200.

May 28 Wrote off Reed’s account, $4,800.

Dec. 15 Wrote off Fischer’s account, $2,300.

Dec. 31 Recorded the bad debts expense assuming Penman’s policy is to record bad debts expense as 0.9% of credit sales. (Hint: The allowance account is increased by 0.9% of credit sales

regardless of write-offs.)

Compute the ending balances in accounts receivable and the allowance for uncollectible accounts. Show how Penman’s December 31 balance sheet reports the two accounts

In: Accounting

Where is nitrogen found in living organisms? How do living organisms uptake nitrogen? What percentage of...

  1. Where is nitrogen found in living organisms?
  2. How do living organisms uptake nitrogen?
  3. What percentage of the atmosphere is nitrogen?
  4. Describe the nitrogen fixation process. Be sure to include nitrate, nitrogen gas, nitrite, and ammonium.
  5. What is assimilation?

In: Biology

Express monetary answers to the nearest whole dollar. Express percentage answers to the nearest hundredth 22.Tiffanywould...

Express monetary answers to the nearest whole dollar. Express percentage answers to the nearest hundredth

22.Tiffanywould like to buy a delivery vehicle for hersmall business. Shecan afford to make a down payment of $7,500 and pay monthly (end-of-month) payments of $1,350. If the term is 48months and the loan rate is 5.24 percent(APR), then what is the maximum that Tiffanycan pay for the delivery vehicle?

23Geraldpurchases a house for $250,000 by getting a mortgage for $225,000 and paying a down payment of $25,000. It is a 20-year mortgage with a 4.92 percent interest rate and Geraldmakes a payment at the end of each month. Suppose the house appreciates at a 2.25 percent rate per year. If equity is the value of the house minus how much is owed on the house, then how much equity does Geraldhave at the end of ten years?

In: Finance

Today, you sold 1 share of Litchfield Design stock. The percentage return over the past quarter...

Today, you sold 1 share of Litchfield Design stock. The percentage return over the past quarter (from 3 months ago to today) for these shares was 9.86 percent. You purchased the shares 3 months ago at a price of 111.98 dollars per share. You just received 6.36 dollars in dividends. What was the price of the stock when you sold it?

In: Finance

1,Ceteris paribus, which countries would you expect to rely MORE on foreign trade as a percentage...

1,Ceteris paribus, which countries would you expect to rely MORE on foreign trade as a percentage of their economic activity?

A larger countries, like the US.

B smaller countries, like Sweden

2. An economy’s net exports always equals (choose one or both)

A the difference between its saving and its investment

B its trade balance

3. An economy’s trade balance always equals (choose one or both)

A net capital outflow

B net foreign investment

In: Economics

Rounded Depreciation Percentages by Recovery Year Using MACRS for First Four Property Classes Percentage by recovery...

Rounded Depreciation Percentages by Recovery Year Using MACRS for
First Four Property Classes
Percentage by recovery year*
Recovery year 3 years 5 years 7 years 10 years
1 33% 20% 14% 10%
2 45% 32% 25% 18%
3 15% 19% 18% 14%
4 7% 12% 12% 12%
5 12% 9% 9%
6 5% 9% 8%
7 9% 7%
8 4% 6%
9 6%
10 6%
11 4%
Totals 100% 100% 100% 100%
A firm is considering renewing its equipment to meet increased demand for its product. The cost of equipment modifications is $1.81 million plus $120,000 in installation costs. The firm will depreciate the equipment modifications under​ MACRS, using a​ 5-year recovery period Additional sales revenue from the renewal should amount to $1.19 million per​ year, and additional operating expenses and other costs​ (excluding depreciation and​ interest) will amount to 38% of the additional sales. The firm is subject to a tax rate of 40 ​(Note​: Answer the following questions for each of the next 6​ years.)
a. What incremental earnings before​ depreciation, interest, and taxes will result from the​ renewal?
b. What incremental net operating profits after taxes will result from the​ renewal?
c. What incremental operating cash inflows will result from the​ renewal?             

In: Finance

Question 3: The Bank of Canada once again reduced its key rate by 0.5 percentage point...

Question 3: The Bank of Canada once again reduced its key rate by 0.5 percentage point on March 24, aligning with the United States. What are the elements of aggregate demand that the Bank of Canada hopes to stimulate through this monetary policy?

In: Economics

The consumer price index increases from 129.7 to 136.4. By how much percentage wise should your...

The consumer price index increases from 129.7 to 136.4. By how much percentage wise should your employer increase your wage if he wants to keep your purchasing power constant? Round to two decimal places and do not enter a % sign.

If the Federal Reserve were to purchase government bonds in the open market, we would expect interest rates in the economy to (increase/decrease)_______ and therefore spending in the future is likely to (increase/decrease)_______.

In: Economics

Simon is recently qualified as a professional accountant after completing the practical requirements with Lau, Ho...

Simon is recently qualified as a professional accountant after completing
the practical requirements with Lau, Ho & Co. Certified Public Accountants (Lau). Soon afterwards, Simon applied for and secured a position with a Lau audit client, which is called Chan Cheung Kee Construction and Investment Co. (CCK). CCK is a Hong Kong based company listed on the Stock Exchange of Hong Kong. Simon has never worked on the audit of CCK before. During his first month at his new job, Simon becomes aware of the fact that a Lau's recommendation was partially or entirely responsible for him having been chosen for his job. Lau's advice is often sought by CCK's senior management. CCK requested Lau to provide some audit working papers relating to CCK's systems and operating procedures so that Simon can use these documents to speed up his training on CCK's system and operating procedures. Lau agreed and subsequently asked a junior audit staff to duplicate extracts from last year's audit working papers. One of the working papers extracts, which probably should not have been photocopied, indicates that Lau charges CCK its audit fee based on a formula that is calculated as a varying percentage, depending on how successful CCK is in its public offerings during the year. Simon does not immediately react by asking any potentially embarrassing questions. However, Simon is concerned with the apparent ethical violation. Simon is also uncertain about the ethical responsibilities that he has to both past and present employers, and to the professional bodies.
Discussion
a. Describe the apparent ethical violation.
b. Describe the ethical responsibilities Simon has.
c. Discuss the course of action that Simon should take

In: Accounting