Its an excel problem. Screenshots and actual work in excel is appreciated.
Suppose a company is about to start the following project, where all the dollar figures are in thousands of dollars. In year 0, the project requires a fixed cost of $12,000. The fixed costs is depreciated on the straight-line basis over five years, and there is a salvage value of $1,500 in year 5. The sales generated in years 1-5 are estimated to be 2,500 units, 3,200 units, 5,100 units, 3,400 units and 1,200 units. The costs of capital in year 1 is forecast to be 8.5% and decreases linearly by 0.2% for years 2 to 5, ending with 7.7% in year 5. The tax rate is forecast to be a constant 35.0%. Sales revenue per unit is forecast to be $8.50. Variable cost per unit is forecast to be $6.30. What is the project NPV? Develop your financial spreadsheet model with frozen panes for detailed calculations and name the worksheet “Project NPV”.
In: Finance
partial income statements for Sherwood company summarized for a four year period show the following
2015 2016 2017 2018
net sales 2,200.000 2,600.000 2,700.000 3,200.000
cost of goods sold 1,496.000 1,742.000 1,863.000 2,176.000
gross profit 704.000 858.000 837.000 1,024.000
an audit reveled that in determining these amounts, the ending inventory for 2016 was overstated by $22,000. the inventory balance on December 31, 2017. was accurately stated. the company uses a periodic inventory system
1\ restate the partial income statements to reflect the correct amounts after fixing the inventory error
2\ compute the gross profit percentage for each year (a) before the correction and (b) after the correction
2.a\ does the pattern of gross profit percentage lend confidence to your corrected amount
In: Accounting
In: Chemistry
On June 28, 1997, in Las Vegas, Nevada, heavyweight boxers Mike Tyson and Evander Holyfield met for what was to be a night to remember. During the third round of the fight, a desperate Tyson bit off a piece of Holyfield’s ear. The fight continued until moments later when Tyson bit Holyfield’s other ear.1 Tyson was disqualified, and numerous fans were unhappy with the outcome. Some fans were so outraged they decided to sue Tyson, the fight promoters, and the telecasters, seeking a refund.2 The fans sued on the basis of, among other theories, a claim to being third-party beneficiaries to various contracts into which the defendants had entered.
2. If you were one of the fight promoters, what sorts of contractual duties would you have to the viewers?
In: Operations Management
Precision Construction entered into the following transactions during a recent year.
| January | 2 | Purchased a bulldozer for $266,000 by paying $28,000 cash and signing a $238,000 note due in five years. | ||
| January | 3 | Replaced the steel tracks on the bulldozer at a cost of $28,000, purchased on account. The new steel tracks increase the bulldozer's operating efficiency. | ||
| January | 30 | Wrote a check for the amount owed on account for the work completed on January 3. | ||
| February | 1 | Repaired the leather seat on the bulldozer and wrote a check for the full $1,600 cost. | ||
| March | 1 | Paid $8,400 cash for the rights to use computer software for a two-year period. |
Required:
1-a. Complete the table below, for the above transactions. (Enter any decreases to Assets, Liabilities, or Stockholders' Equity with a minus sign.)
1-b. Prepare the journal entries for each of the above transactions.
2. For the tangible and intangible assets acquired in the preceding transactions, determine the amount of depreciation and amortization that Precision Construction should report for the quarter ended March 31. The equipment is depreciated using the double-declining-balance method with a useful life of five years and $48,000 residual value.
3. Prepare a journal entry to record the depreciation and amortization calculated in requirement 2.
In: Accounting
Compare and contrast the approaches of Smith, Ricardo, Marx, Veblen, and Schumpeter to an understanding of “the machine” or capital and its development? How does their approach to the machine support their view of economic society, specifically class structure?
In: Economics
How can you determine which compound is a stronger acid/base if neither compound is a strong acid or a strong base? Chapter 16, question 45 c. in chemistry a molecular approach textbook
In: Chemistry
Discuss the real–world applications where probabilities are used. (Ex. Stock market trading; Medical treatment plans; etc.)
In: Math
Using Python 3
Write a program that reads the 4letterwords.txt file and outputs a file called 4letterwords.out that has every word found in 4letterwords.txt but each word on one line. Any leading and trailing blank spaces must be removed in the output file.
In: Computer Science
In: Computer Science
Out of the choices provided, which is the best recrystallizing solvent for resorcinol and why?
a. Water
b. Petroleum ether
c. Ethanol
In: Chemistry
During the mismatch repair of DNA, the repair enzyme
will remove several nucleotides on both DNA strands.
will remove several nucleotides on one DNA strand.
will remove only the mismatched nucleotide.
will remove the mismatched nucleotide, and the same enzyme will replace it with the correct nucleotide.
is unable to detect mutations.
In: Biology
Problem 16-4 Change in tax rate; record taxes for four years [LO16-1, 16-5]
Zekany Corporation would have had identical income before taxes
on both its income tax returns and income statements for the years
2018 through 2021 except for differences in depreciation on an
operational asset. The asset cost $130,000 and is depreciated for
income tax purposes in the following amounts:
| 2018 | $ | 42,900 | |
| 2019 | 57,200 | ||
| 2020 | 19,500 | ||
| 2021 | 10,400 | ||
The operational asset has a four-year life and no residual value.
The straight-line method is used for financial reporting
purposes.
Income amounts before depreciation expense and income taxes for
each of the four years were as follows.
| 2018 | 2019 | 2020 | 2021 | |||||||||
| Accounting income before taxes and depreciation | $ | 75,000 | $ | 95,000 | $ | 85,000 | $ | 85,000 | ||||
Assume the average and marginal income tax rate for 2018 and 2019
was 30%; however, during 2019 tax legislation was passed to raise
the tax rate to 40% beginning in 2020. The 40% rate remained in
effect through the years 2020 and 2021. Both the accounting and
income tax periods end December 31.
Required:
Prepare the journal entries to record income taxes for the years
2018 through 2021. (If no entry is required for a
transaction/event, select "No journal entry required" in the first
account field.)
In: Accounting
Write a procedure of bubble sort to sort the array of byte. This
procedure receives
two arguments, firstly it receives the offset of array in SI
register, secondly BX
contains number of elements. Write a program that user Enter a
single digit
number, these numbers have one space between them, call bubble sort
procedure
for sorting the numbers
8086 assembly code
In: Computer Science
In: Operations Management