Hello,I need you to solve questions 1 to 10.I expect this case to cost me $60 Document Preview: CASE70M a e h m Print_Area_MI CASE70M.XLS Student Version POTATO BEST PRODUCTS Capital Budgeting Methods and Cash Flow Estimation This case focuses on capital budgeting decision criteria and cash flow estimation. It includes basic concepts such as incremental cash flows, sunk costs, opportunity costs, and externalities and then moves to inflation adjustments. The model develops incremental cash flow estimates, then calculates NPV, IRR, MIRR, and Payback for new pasta equipment. If you are using the student version of the model, some of the cells have been blanked out. Before using the model, it is necessary to fill in the empty cells with the appropriate formulas. Once this is done, the model is ready for use. The following cells have been blanked out: C34, C39, C47, C55:C58, F59:G60, C75, D76:D77, D79:D82, D84, D86, D88:D89, D91:D92, D94, and D102. = INPUT DATA: KEY OUTPUT: Initial Inv.: Equipment Equipment cost NPV Freight IRR Installation MIRR Change in NWC Payback years Operating Flows and Inflation Rates: Unit sales t=0 sales price Fixed oper costs t=0 VC per unit Other Cash Flows and Inflation Rates: Opp. cost (lost rent) Price inflation Cost inflation SV, Taxes, and C of C: Salvage value Useful life (yrs) Tax rate Cost of capital MODEL-GENERATED DATA TABLE 1 ADDITIONAL PASTA MACHINES INITIAL INVESTMENT AND DEPRECIATION Net Investment Outlay: Depreciation Schedule: Basis: MACRS Dep. End of Year Year Factor Expense Book Value ======== total TABLE 2 ADDITIONAL PASTA MACHINE NET CASH FLOWS Cash Flows: Year Year 0 1 2 3 4 5 6 7 8 9 10 Initial Investment Unit price Revenues Fixed operating costs Variable operating costs Opportunity costs Total costs Depreciation Before tax income Taxes Net income Plus depreciation Net op cash flow SV tax Recovery of Attachments: Potato-Best.pdf potatobest.xls