Week 5 Practice Set 11-19

Hi expert please give me answer general accounting question

Week 8 Excel Spreadsheet to be used with the Practice Set: Years Acquisition stage cash flow: Initial Outlay Operating stage cash flow: Sales Fixed Cost Variable Cost Depreciation expense Taxable income Taxes 0 (800,000) 1 2 3 4 5 6 7 8 After tax income Add back depreciation Operating cash flows 600,000 600,000 600,000 600,000 (220,000) (220,000) (220,000) (220,000) (240,000) (240,000) (240,000) (240,000) (68,000) (68,000) (68,000) (68,000) 72,000 72,000 72,000 72,000 (20,160) (20,160) (20,160) (20,160) 51,840 51,840 51,840 68,000 68,000 68,000 119,840 119,840 119,840 51,840 68,000 119,840 600,000 600,000 600,000 600,000 (220,000) (220,000) (220,000) (220,000) (240,000) (240,000) (240,000) (240,000) (68,000) (68,000) (68,000) (68,000) 72,000 72,000 72,000 72,000 (20,160) (20,160) (20,160) (20,160) 51,840 51,840 51,840 51,840 68,000 68,000 68,000 68,000 119,840 119,840 119,840 119,840 Disposition stage cash flow: 500,000 Total cash flow Present Value (800,000) 872,591 119,840 119,840…

Subject: accounting

Subject: accounting

Sub. General accounting

eBook Show Me How Print Item Determine Cash Flows Marigold Inc. is planning to invest in new manufacturing equipment to make a new garden tool. The garden tool is expected to generate additional annual sales of 9,700 units at $52 each. The new manufacturing equipment will cost $210,100 and is expected to have a 10-year life and $16,100 residual value. Selling expenses related to the new product are expected to be 4% of sales revenue. The cost to manufacture the product includes the following on a per-unit basis: Direct labor $8.80 Direct materials 28.90 Fixed factory overhead-depreciation 2.00 Variable factory overhead 4.50 Total $44.20 Determine the net cash flows for the first year of the project, Years 2-9, and for the last year of the project. Use a minus sign to indicate cash outflows. Do not round your intermediate calculations but, if required, round your final answer to the nearest dollar. Marigold Inc. Net Cash Flows Year 1 Years 2-9 Last Year Initial investment Operating cash…

QUESTION 9 Home Express Moving Company is considering purchasing new equipment that costs $728,000. Its management estimates that the equipment will generate cash inflows of $50,000 semiannually for its 2 year life. Present value of $1: 6% 1 2 3 4 5 0.943 0.890 0.840 0.792 0.747 O $235,750 O $100,000 O $200,000 Ⓒ$152,600 7% 8% 0.917 0.926 0.857 0.842 0.772 0.708 0.650 9% 0.935 0.873 0.816 0.794 0.763 0.735 0.713 0.681 10% 0.909 0.826 0.751 0.683 0.621 The company's annual required rate of return is 14%. Using the factors in the table, calculate the present value of the cash flows

A B C D E F G H 1 Create a income statement and show net cashflow each year for the 4 years so you can use it for what-if analysis. 2 3 Base case Inputs: 4 5 6 4-year life of the project $26/unit Sales price of product 7 $13/unit Cost to produce the product 8 $1450/year operating costs 9 1250 units First-year production 16% Increase in production each year 1012345167819202123 24 25 26 14 Answer the following question for "what if analysis" 16 What is the IRR for the Base case? 17 $32,000 Initial investment depreciated with MACRS 3 year recovery 28% tax rate What is the IRR if the volume produced does not increase by 16%/year, but only increased 10%/yr.? What is the IRR if the sales price is only $24/unit? What is the IRR if the tax rate increases to 49%? 20 What is the IRR if the initial investment is $39,000? 18 19 22 Which analysis should your company be most concerned about? I J k

Exercise 24-4 (Algo) Payback period, unequal cash flows, and depreciation adjustment LO P1 A machine can be purchased for $200,000 and used for five years, yielding the following income. This income computation includes annual depreciation expense of $40.000. Income Year 1 $13,500 Year 2 $33,500 Year 3 $83,000 Year 4 $50,500 Year 5 $134,000 Compute the machine's payback period. (Round payback period answer to 2 decimal places.) Year Net Income Depreciation Net Cash Flow Cumulative Net Cash Flow Initial invest $ (200,000) $ (200,000) Year 1 $ 13,500 Year 2 33,500 Year 3 83,000 Year 4 50,500 Year 5 134,000 0 0 Payback period=

Balance of Cash after AJE (in unit dollars, two decimal places, use standard accounting rounding): After completing Part C of the term project you have the following: Revenue 100,000.00 15,000.00 45,000.00 CGS Costs Depreciation 15,000 Salaries 30,000 Net Income Assets Cash 40,000.00 110,000.00 20,000.00 Equipment 100,000.00 AD Equipment (10,000.00) Answer: Liabilities 70,000.00 Salaries Payable 70,000.00 Net Income 40,000.00 Total Liabilities + OE 110,000.00

Exercise 24-4 (Algo) Payback period, unequal cash flows, and depreciation adjustment LO P1 A machine can be purchased for $130,000 and used for five years, yielding the following income. This income computation includes annual depreciation expense of $26,000. Income Year 1 $8,800 Year 2 $21,800 Year 3 $57,000 Year 4 $32,900 Year 5 $87,200 Compute the machine's payback period. (Round payback period answer to 2 decimal places.) × Answer is complete but not entirely correct. Year Net Income Depreciation Net Cash Flow Cumulative Net Cash Flow Initial invest $ (130,000) $ (130,000) Year 1 $ 8,800 $ 26,000 34,800 34,800 x Year 2 21,800 26,000 47,800 82,600 × Year 3 57,000 26,000 83,000 130,000 ☑ Year 4 32,900 26,000 Year 5 87,200 26,000 Payback period = 2.57 years

After spending $10,000 on client-development, you have just been offered a big production contract by a new client. The contract will add $200,000 to your revenues for each of the next five years and it will cost you $100,000 per year to make the additional product. You will have to use some existing equipment and buy new equipment as well. The existing equipment is fully depreciated, but could be sold for $50,000 now. If you use it in the project, it will be worthless at the end of the project. You will buy new equipment valued at $30,000 and use the 5-year MACRS schedule to depreciate it. It will be worthless at the end of the project. Your current production manager earns $80,000 per year. Since she is busy with ongoing projects, you are planning to hire an assistant at $40,000 per year to help with the expansion. You will have to immediately increase your inventory from $20,000 to $30,000. It will return to $20,000 at the end of the project. Your company's tax rate is 35% and your…

Problem 6 - Shirt Corporation is considering purchasing equipment that costs $60,000 and is expected to provide the following cash inflows over its five-year useful life:   Year Cash Inflow 1 $18,000 2 $22,000 3 $24,000 4 $16,000 5 $ 9,000                 Calculate the payback period for this investment.

Consider the table of projected NOI cash flows for a commercial real estate asset below. Year 1 Year 2 Year 3 Year 4 Year 5 $ 150,000 $ 157,500 $ 165,375 $ 173,644 $ 182,326 If the building is sold at the end of Year 3 at a 7.25% going-out cap rate, and 4.50% in selling expenses are incurred, what is the total cash flow (TCF) in year 3?

QUESTION 5 Your firm has net income of $343 on total sales of $1,360. Costs are $750 and depreciation is $120. The tax rate is 30 percent. The firm does not have interest expenses. What is the operating cash flow? $833 $463 $610 $343 $490 QUESTION 6 Seaborn Co. has identified an investment project with the following cash flows. Year Cash Flow $950 1,050 1 2 3 4 1,320 1,200 If the discount rate is 10 percent, what is the present value of these cash flows? O3542.76 3578.84 3418.66 4470.00 3847.03 Click Save and Submit to save and submit. Click Save All Answers to save all answers. Save All Answers

6

Question Content Area A project is estimated to cost $273,840 and provide annual net cash inflows of $60,000 for 7 years. Year 6% 10% 12% 1 0.943 0.909 0.893 2 1.833 1.736 1.690 3 2.673 2.487 2.402 4 3.465 3.170 3.037 5 4.212 3.791 3.605 6 4.917 4.355 4.111 7 5.582 4.868 4.564 8 6.210 5.335 4.968 9 6.802 5.759 5.328 10 7.360 6.145 5.650 Determine the internal rate of return for this project by using the above present value of an annuity table.fill in the blank 1 of 1%

Relevant Cash Flow Data for Year 2:Sales revenues Year 2 $100,000Cost of Goods Sold 20,000Depreciation Expense 10,000Tax Rate 40% Based on the above cash flow data: What is the operating cash flow for year two of this capital budgeting project? A.130,000 B.52,000 C.42,000 D. 78,000

Problem 9-06 Assume Lasher's Kitchen has pretax earnings of $50,000 after depreciation expense of $10,000. If the firm's tax rate is 20 percent, what is its cash flow from operations? Round your answer to the nearest dollar. $

General accounting question

Depreciation rates Year 1 Year 2 33.33% Year 3 44.45% 14.81% Year 4 7.41% Complete the following table and calculate incremental cash flows in each year. Hint: Round your answers to the nearest dollar and remember to enter a minus sign if the calculated value is negative. Year 0 Year 1 Year 2 Year 3 Year 4 New machine cost $1,700 After-tax salvage value, old machine $700 Sales revenues $4,500 $4,500 Operating costs except depreciation $380 $380 $4,500 $380 $4,500 $380 Operating income $ $3,364 $3,868 $3,994 After-tax operating income $2,018 $2,321 $2,396 Net cash flows after replacement (adding back depreciation) Incremental Cash Flows $ $ $2,774 $2,321 $2,522 $394 $193 $142 Next evaluate the incremental cash flows by calculating the net present value (NPV), the internal rate of return (IRR), and the modified IRR (MIRR). Assume again that the cost of financing the new project is the same as the WACC and equals 10%. Hint: Use a spreadsheet program's functions or use a financial…

Accounting

Need help with this general accounting question