PLEASE NOTE!!! they are all connected.answer all for upvote 
27)
SPREADSHEET ANALYSIS: CASH FLOW ESTIMATION. FOR THIS AND THE NEXT 9. Omni Cocoa Farms (OCF) is a firm that makes raw cocoa powder. As part of an ongoing expansion program, it plans to purchase a new processor costing $2 million. An additional $30,000 would be required to modify the equipment for factory use. Shipping and installation charges are $1,200 and $1,000, respectively. The machine will be used for 4 years. Also, it will be fully depreciated using straightline method over 4 years at the end of which, it can be sold for 30% of its original value. Once fully operational, the machine is expected to generate incremental sales of 18,000 boxes of raw cocoa powder per year for 4 years. The per unit sales price in the first year is $80. Also, in the first year, the total incremental operating cost (excluding depreciation) is projected to be 60% of total sales. Both the sales price and operating costs are expected to increase by 2.5% per year due to inflation. To place the new equipment into full operation, OCF will need to increase the amount of cocoa pods it processes. Cocoa pod is the raw material used for making cocoa powder. The cost of this initial increase in raw materials is expected to be $110,000. For each of the subsequent years, net working capital (NWC) is projected to be 25% of total sales expected in the following year. For example, NWC for Year 1 0.25(Year 2 sales), etc. Half of the initial investment in this project will be borrowed at an interest rate of 8.5%. A non-refundable insurance premium of $1,000 for this investment was pre- and operating costs are expected to increase by 2.5% per year due to inflation. To place the new equipment into full operation, OCF will need to increase the amount of cocoa pods it processes. Cocoa pod is the raw material used for making cocoa powder. The cost of this initial increase in raw materials is expected to be $110,000. For each of the subsequent years, net working capital (NWC) is projected to be 25% of total sales expected in the following year. For example, NWC for Year 1 = 0.25(Year 2 sales), etc. = Half of the initial investment in this project will be borrowed at an interest rate of 8.5%. A non-refundable insurance premium of $1,000 for this investment was pre- paid 2 years ago. The firm's tax rate is 40% and the cost of capital is 10%. CALCULATE THE DEPRECIABLE COST OF THIS INVESTMENT. 1) $2,032,200 2) $2,026,700 3) $2,000,000 4) $1,026,700 5) None of the above How much is the annual depreciation? 1) $256,675 2) $1,524,150 3) $508,050 4) $2,126,700 5) None of the above Question 23 (1 point) Calculate the total initial cost of this investment, i.e. net cash flow at t = 0. 1) $2,142,200 2) $2,000,000 3) $2,026,700 04) $2,126,700 Question 24 (1 point) What is the net cash flow for Year 1? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above Question 25 (1 point) What is the net cash flow for Year 2? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above Question 26 (1 point) What is the final net cash flow - after adjustments - for Year 4? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above What is the NPV of this investment? 1) -$103,586 2) -$240,000 3) $220,478 4) None of the above Questi 28 (1 point) Calculate the Modified Internal Rate of Return (MIRR) for this project. 1) 8.18% 2) 19.13% 3) 8.65% 4) 17.12% Question 29 (1 point) Under what circumstance would this project be accepted? 1) If the project's profitability index > 0 2) If the project's MIRR > IRR 3) If project's IRR > Crossover rate. 4) If the project's profitability index > 1 Question 30 (1 point) Consider the amount to be borrowed. Assume the loan will be amortized - monthly - for 4 years. How much is the total monthly payment? 1) $26,400.80 2) $13,885.62 3) $48,858.19 4) $326,993.86 SPREADSHEET ANALYSIS: CASH FLOW ESTIMATION. FOR THIS AND THE NEXT 9. Omni Cocoa Farms (OCF) is a firm that makes raw cocoa powder. As part of an ongoing expansion program, it plans to purchase a new processor costing $2 million. An additional $30,000 would be required to modify the equipment for factory use. Shipping and installation charges are $1,200 and $1,000, respectively. The machine will be used for 4 years. Also, it will be fully depreciated using straightline method over 4 years at the end of which, it can be sold for 30% of its original value. Once fully operational, the machine is expected to generate incremental sales of 18,000 boxes of raw cocoa powder per year for 4 years. The per unit sales price in the first year is $80. Also, in the first year, the total incremental operating cost (excluding depreciation) is projected to be 60% of total sales. Both the sales price and operating costs are expected to increase by 2.5% per year due to inflation. To place the new equipment into full operation, OCF will need to increase the amount of cocoa pods it processes. Cocoa pod is the raw material used for making cocoa powder. The cost of this initial increase in raw materials is expected to be $110,000. For each of the subsequent years, net working capital (NWC) is projected to be 25% of total sales expected in the following year. For example, NWC for Year 1 0.25(Year 2 sales), etc. Half of the initial investment in this project will be borrowed at an interest rate of 8.5%. A non-refundable insurance premium of $1,000 for this investment was pre- and operating costs are expected to increase by 2.5% per year due to inflation. To place the new equipment into full operation, OCF will need to increase the amount of cocoa pods it processes. Cocoa pod is the raw material used for making cocoa powder. The cost of this initial increase in raw materials is expected to be $110,000. For each of the subsequent years, net working capital (NWC) is projected to be 25% of total sales expected in the following year. For example, NWC for Year 1 = 0.25(Year 2 sales), etc. = Half of the initial investment in this project will be borrowed at an interest rate of 8.5%. A non-refundable insurance premium of $1,000 for this investment was pre- paid 2 years ago. The firm's tax rate is 40% and the cost of capital is 10%. CALCULATE THE DEPRECIABLE COST OF THIS INVESTMENT. 1) $2,032,200 2) $2,026,700 3) $2,000,000 4) $1,026,700 5) None of the above How much is the annual depreciation? 1) $256,675 2) $1,524,150 3) $508,050 4) $2,126,700 5) None of the above Question 23 (1 point) Calculate the total initial cost of this investment, i.e. net cash flow at t = 0. 1) $2,142,200 2) $2,000,000 3) $2,026,700 04) $2,126,700 Question 24 (1 point) What is the net cash flow for Year 1? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above Question 25 (1 point) What is the net cash flow for Year 2? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above Question 26 (1 point) What is the final net cash flow - after adjustments - for Year 4? 1) $548,235 2) $556,860 3) $575,393 4) $1,323,074 5) $289,820 6) None of the above What is the NPV of this investment? 1) -$103,586 2) -$240,000 3) $220,478 4) None of the above Questi 28 (1 point) Calculate the Modified Internal Rate of Return (MIRR) for this project. 1) 8.18% 2) 19.13% 3) 8.65% 4) 17.12% Question 29 (1 point) Under what circumstance would this project be accepted? 1) If the project's profitability index > 0 2) If the project's MIRR > IRR 3) If project's IRR > Crossover rate. 4) If the project's profitability index > 1 Question 30 (1 point) Consider the amount to be borrowed. Assume the loan will be amortized - monthly - for 4 years. How much is the total monthly payment? 1) $26,400.80 2) $13,885.62 3) $48,858.19 4) $326,993.86
