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

30- The cost of the 2020 model "Passat Impression 1.5 TSI ACT 150 PS 7-speed DSG" vehicle, acquired on 17.08.2020 to be used in management activities, is 300.000 TL. What is the amount of depreciation to be allocated in the last year according to the prorated depreciation method for this vehicle with an economic life of 10 years? a) 30.000 TL B) 47.500 TL NS) 17.500 TL D) 60.000 TL TO) 12.500 TL
Do tbe question using straight kine method double declining method and number of unit production method
es Problem 12-27 (Algo) MACRS depreciation and net present value [LO12-4] Universal Electronics is considering the purchase of manufacturing equipment with a 10-year midpoint in its asset depreciation range (ADR). Carefully refer to Table 12-11 to determine in what depreciation category the asset falls. (Hint: It is not 10 years.) The asset will cost $220,000, and it will produce earnings before depreciation and taxes of $72,000 per year for three years, and then $35,000 a year for seven more years. The firm has a tax rate of 25 percent. Assume the cost of capital is 14 percent. In doing your analysis, if you have years in which there is no depreciation, merely enter a zero for depreciation. Use Table 12-12. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods. a. Calculate the net present value. Note: Do not round intermediate calculations and round your answer to 2 decimal places. Net present value b. Based on the…
30-31
Problem 11 The following consignment-related transactions were made by Juno Company in December 2020:  Consigned to Atlan Company 10,000 units of tools at P500 each and paid freight ofP50,000. Each unit costs P200. They agreed that Atlan’s commission is P10 per unit. Bythe end of the year, only 2,000 units remained unsold by Atlan. Consigned 5,000 units of tools to Skye at P600 each and paid freight of P50,000. Totalcost of the consigned items was P1,500,000. Skye agreed to undertake the consignmentif she will get a commission of 10% per unit sold. By the end of the year, only 2,000 unitswere sold by Skye. Assuming that Juno Company maintains its inventory records using the perpetual inventorysystem, prepare the journal entry to record the sales when Atlan and Skye remitted their sales.Prepare separate entry for each consignee
25 01:08:30 Consider a four-year project with the following information: initial fixed asset investment = $488,000; straight-line depreciation to zero over the four-year life; zero salvage value; price = $39; variable costs $30; fixed costs $208,000; quantity sold 97,000 units; tax rate=34%. How sensitive is OCF to changes in quantity sold? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) AOCF/AQ
None
Cost of new equipment: $200,000 Installation: $20,000 Change in Net Operating Working Capital: $50,000 New sales per year: $115,000 New operating costs per year: $50,000 Economic life: 4 years Depreciable life: MACRS 3-year class (33%, 45%, 15%, 7%) Salvage value: $20,000 Tax Rate: 25% WACC: 9% What is the total initial investment outlay (FCF0)? What is the operating cash flow for year 2, or FCF2? (SHOW ALL WORK/STEPS) What are the planned non-operating cash flows in year 4 (i.e. terminal cash flows)? (SHOW ALL WORK/STEPS) What is the book value of the equipment after three years?
40. An asset that cost P15,000 new has an estimated scrap value of P2,000 at the end of 10 years using constant percentage method, determine the rate of depreciation and the Book value at the end of 8 years. a. K=18.25%; BV = 3000 b. K=20.10; BV = 2934.40 c. K=18.25%; BV = 2992.22 d. K= 20.10% BV = 3000 e. None of the above
Question WX Company produced an oil based chemical product which it sells to paint manufacturers. Because of the unique nature of the chemical product, price is not driven by the market. In year 2020 with good market condition, it incurred total cost of $412,000 to produce the chemical. The invested asset is $1,487,500. The cost per unit to manufacture a gallon of the chemical is presented as below- Direct Labor $2Direct Material $5Apart from this, the variable manufacturing overhead is incurred at a rate of 40% of the cost of direct labor. Assume that 40% of the variable manufacturing cost is indirect labor, 35% of the variable manufacturing cost is indirect material and the remaining 25% is utilities. Fixed manufacturing overhead is also incurred. WX Company decided to price its product to earn a 16% return on its investment, and it has taken into account the total cost plus the mark up when pricing its chemical product. The market price of the chemical is $13.3. In year 2019, it…
A3
sa