| 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 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
In: Biology
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 (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 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 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 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 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
In: Accounting