Year 0 1 2 3 4 5 Unit Price - $105 $110 $1 15 $120 $125 Units Sold - 900 1000 1100 1200 1300 Net Sales - Variable Costs - $54 ,000 $60,000 $66,000 $72,000 $78,000 Fixed Costs - $15,000 $15,750 $16,538 $17 ,364 $18,233 Depreciation - $10,000 $10, 000 $10,000 $10,000 $10,000 PBIT - Tax@40% - NOPAT - Adjustments: Add back Depreciation - CapEx -$100,000 --- -- Salvage value ---- $40,000 Net cash flow Cumulative cash flow Use an Excel spreadsheet to graph the cumulative cash flow.

Year 0 1 2 3 4 5 Unit Price - $105 $110 $1 15 $120 $125 Units Sold - 900 1000 1100 1200 1300 Net Sales - Variable Costs - $54 ,000 $60,000 $66,000 $72,000 $78,000 Fixed Costs - $15,000 $15,750 $16,538 $17 ,364 $18,233 Depreciation - $10,000 $10, 000 $10,000 $10,000 $10,000 PBIT - Tax@40% - NOPAT - Adjustments: Add back Depreciation - CapEx -$100,000 --- -- Salvage value ---- $40,000 Net cash flow Cumulative cash flow Use an Excel spreadsheet to graph the cumulative cash flow.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

acc1
Equipment $10,000 Goodwill $35,000 $45,000 Equipment was expected to last five more years from date of acquisition and is still owned at year end. Goodwill was written down by $5,000 in 2018. In 2019, Premier sold JV land, reporting a gain of $20,000. JV still has the land. In 2019, JV sold Premier inventory for $30,000 reporting a profit of $6,000. $15,000 of the inventory was still held by Premier at the end of 2019 and sold early in 2020. In 2020, JV reported net income of $35,000 and declared and paid total dividends of $15,000. At December 31, 2020, JV had retained earnings of $160,000. Premier uses the equity method to record the investment in JV. Tax rate is 25%. Calculate the equity method income related to JV for 2020 reported by Premier.
Type of Cost 1 2 Selling and Administrative salaries and expenses 3 Direct Labor (Estimated 40,000 DL hours @ average wage rate of $12 per hour) 4 Indirect plant labor 5 Plant utilities 6 Purchases of direct materials 7 Lease and property taxes on the plant 8 Marketing expenses Depreciation on production equipment (equipment originally costing $700,000 three year ago is being depreciated over a 5 year useful life using straight-line depreciation. No salvage value is 9 expected.) 10 Indirect materials to be used in the plant 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Estimated total cost for the year S 210 000 $ $ S $ $ $ $ 40 000 50 000 1 400 000 120 000 30 000 20 000 24・・ 23・・ 22・・ 21 20 Req. 1: Before the year began, Custom Fabric Ventures estimated the following costs for the year: See Excel file: Estimated Annual Costs First, fill in the missing costs. Then, calculate the company's predetermined manufacturing overhead rate, assuming the company uses direct labor…
Question Content Area Falkland, Inc., is considering the purchase of a patent that has a cost of $51,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 10%. The patent is expected to generate the following amounts of annual income and cash flows: Year 1 Year 2 Year 3 Year 4 Net income $5,100 $6,500 $6,300 $3,000 Operating cash flows 16,900 18,200 18,450 14,800 (Click here to see present value and future value tables) A. What is the NPV of the investment? Round your present value factor to three decimal places and final answer to the nearest dollar. $fill in the blank 1 B. What happens if the required rate of return increases? If the required rate of return increases, . Please round off please?
Problem 10-3 (Algo) Acquisition costs [LO10-1, 10-4, 10-6] The plant asset and accumulated depreciation accounts of Pell Corporation had the following balances at December 31, 2020: Accumulated Depreciation $ Land Land improvements Building Equipment Automobiles Plant Asset $ 480,000 245,000 2,150,000 1,184,000 215,000 Transactions during 2021 were as follows: a. On January 2, 2021, equipment were purchased at a total invoice cost of $325,000, which included a $6,800 charge for freight. Installation costs of $40,000 were incurred. b. On March 31, 2021, a small storage building was donated to the company. The person donating the building originally purchased it three years ago for $32,000. The fair value of the building on the day of the donation was $21,000. c. On May 1, 2021, expenditures of $63,000 were made to repave parking lots at Pell's plant location. The work was necessitated by damage caused by severe winter weather. The repair doesn't provide future benefits beyond those…
11-8 Book value and taxes on sale of assets Troy Industries purchased a new machine 3 years ago for $80,000. It is being depreciated under MACRS with a 5-year recovery period using the percentages given in Table 4.2 on page 000. Assume a 40% tax rate. a. What is the book value of the machine? b. Calculate the firm's tax liability if it sold the machine for each of the following amounts: $100,000; $56,000; $23,200; and $15,000.
None
Required information Problem 10-7A (Algo) Natural resources LO P3 (The following information applies to the questions displayed below.) On July 23 of the current year, Dakota Mining Company pays $6,929,280 for land estimated to contain 9,624,000 tons of recoverable ore. It instals and pays for machinery costing $577,440 on July 25. The company removes and sells 496,750 tons of ore during its first five months of operations ending on December 31, Depreciation of the machinery is in proportion to the mine's depletion as the machinery will be abandoned after the ore is mined. Problem 10-7A (Algo) Part 1-4 Required: Prepare entries to record the following (a) The purchase of the land. (b) The cost and installation of machinery. (c) The first five months' depletion assuming the land has a net salvage value of zero after the ore is mined. (d) The first five months' depreciation on the machinery.
Year 1 2 Revenues $ 60,000 40,000 Saved 3 4 Thereafter 30,000 10,000 0 Expenses are expected to be 30% of revenues, and working capital required in each year is expected to be 10% of revenues in the following year. The product requires an immediate investment of $81,000 in plant and equipment. Required: ok nt ences a. What is the initial investment in the product? Remember working capital. b. If the plant and equipment are depreciated over 4 years to a salvage value of zero using straight-line depreciation, and the firm tax rate is 20%, what are the project cash flows in each year? c. If the opportunity cost of capital is 10%, what is project NPV? d. What is project IRR? Complete this question by entering your answers in the tabs below. Req A Req B Req C and D c. If the opportunity cost of capital is 10%, what is project NPV? Note: A negative value should be indicated by a minus sign. Do not round intermediate calculations. Round your answer to 2 decimal places. d. What is project IRR?…
4.21 answer is incorrect
Exercise 13-17A (Algo) Asset replacement decisions-opportunity cost LO 13-5 Jordan Freight Company owns a truck that cost $42.000 Currently, the truck's book value is $22,000, and its expected remaining useful life is five years. Jordan has the opportunity to purchase for $30100 a replacement truck that is extremely fuel efficient. Fuel cost for the old truck is expected to be $5,600 per year more than fuel cost for the new truck. The old truck is paid for but, in spite of being in good condition, can be sold for only $10,000 Required Calculate the total relevant costs. Should Jordan replace the old truck with the new fuel-efficient model, or should it continue to use the old truck until it wears out? Total relevant costs Should Jordan replace or continue the old truck? Keep Old Replace the old truck Replace With New
Ma3 please Answer fast