This is cost accounting

I need questions answered in excel and the clear answers to nper, pmt, cash inflows, fv, and

Access your blank Excel file here to show your work on questions 2, 3, and 4. Once you download the Excel file, be sure to save your file: use File - Save As - Desktop. Name the file with your last name followed by Final Exam. You must submit the Excel file showing your work for questions 2, 3, and 4. If the file is not submitted, you will lose 6 points on the exam (2 points deducted each on questions 2, 3, and 4). If you do submit your Excel, but do not show your work for questions 2, 3, or 4, you will lose 2 points for each question that did not have work shown in the Excel. Save your Excel file often. It is your responsibility to save your Excel file - you never know when computers can crash! You may use this file for the entire test, but the only required questions for Excel are 2, 3, and 4. Be sure to upload the excel before time runs out. I will not offer any partial credit unless your Excel file is uploaded back to this page before time runs out! Time remaining: 2:54:00 2. value: 11.00 points Gaston Company is considering a capital budgeting project that would require a $2,300,000 investment in equipment with a useful life of five years and no salvage value. The company's tax rate is 30% and its after-tax cost of capital is 13%. It uses the straight-line depreciation method for financial reporting and tax purposes. The project would provide net operating income each year for five years as follows: Sales Variable expenses Contribution margin $ 3,100,00 0 1,690,00 0 1,410,00 0 Fixed expenses: Advertising, salaries, and 530,00 $ other fixed out-of-pocket costs 0 460,00 Depreciation 0 Total fixed expenses Net operating income 990,000 $ 420,000 Required: Compute and enter the following data: The project's undiscounted annual cash inflows. Be sure to consider income taxes. The Excel Inputs used to calculate the present value of the cash inflows (assume you are calculating the present value for the entire project using one pv formula.) The project's net present value. (Use Microsoft Excel to calculate present values, and do not round intermediate calculations. Enter cash outflows as negative numbers.) I need the following below answered in excel Undiscounted Cash Flows: Annual Cash Inflows: Formula Inputs: RATE: NPER: PMT: FV: NPV Calculation: Present Value of Cash Inflows: Cost of Machine: Net present value 3. value: 11.00 points Tranter, Inc., is considering a project that would have a nine-year life and would require a $3,300,000 investment in equipment. At the end of nine years, the project would terminate and the equipment would have no salvage value. The project would provide net operating income each year as follows: (Ignore income taxes.) Sales Variable expenses Contribution margin Fixed expenses: Fixed out-of-pocket cash expenses Depreciation Net operating income $2,700,000 1,700,000 1,000,000 $400,000 260,000 660,000 $ 340,000 All of the above items, except for depreciation, represent cash flows. The company's required rate of return is 10%. Required: a. Enter the appropriate Excel function parameters and compute the project's internal rate of return. (Use Microsoft Excel to calculate the Internal Rate of Return and round your final answer to two decimal places NPER PMT PV FV Internal Rate of Return: 4. value: 11.00 points Welti Corporation has provided the following information concerning a capital budgeting project: After-tax discount rate Tax rate Expected life of the project Investment required in equipment Salvage value of equipment Annual sales Annual cash operating expenses 11% 30% 4 $136,000 $0 $320,000 $230,000 The company uses straight-line depreciation on all equipment; the annual depreciation expense will be $34,000. Assume cash flows occur at the end of the year except for the initial investments. The company takes income taxes into account in its capital budgeting. The net present value of the project is closest to: (Consider income taxes when calculating the net present value. Use Microsoft Excel to calculate present values and do not round intermediate calculations. Round only your final answer to the nearest dollar amount.) $156,800 $68,142 $227,140 $91,099