Develop a financial feasibility study for a radiators' factory in an excel sheet. Please assume that the total cost of the factory is C million SR. Show all the expenses details such as land cost, machine cost, etc. for the establishment and running costs. C equals = 9 The Annual Percentage Rate (APR) =10% Adjust all other assumptions in the excel sheet so that the Net Present Value (NPV) = 2 Million SR in 4 %3D years.

Develop a financial feasibility study for a radiators' factory in an excel sheet. Please assume that the total cost of the factory is C million SR. Show all the expenses details such as land cost, machine cost, etc. for the establishment and running costs. C equals = 9 The Annual Percentage Rate (APR) =10% Adjust all other assumptions in the excel sheet so that the Net Present Value (NPV) = 2 Million SR in 4 %3D years.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 17EA: Gardner Denver Company is considering the purchase of a new piece of factory equipment that will...

See similar textbooks

Similar questions

Information for two alternative projects involving machinery investments follows. Project 1 requires an initial investment of $132,300. Project 2 requires an initial investment of $99,000. Assume the company requires a 10% rate of return on its investments. (PV of $1. FV of $1. PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Annual Amounts Sales of new product Expenses Materials, labor, and overhead (except depreciation) Depreciation Machinery Selling, general, and administrative expenses Income Years 1-7 Project 1 Net present value Years 1-5 Compute the net present value of each potential investment. Use 7 years for Project 1 and 5 years for Project 2. (Negative net present values should be indicated with a minus sign. Round your present value factor to 4 decimals. Round your answers to the nearest whole dollar.) Project 2 Net present value $ Project 1 $ 107,100 Present Value Net Cash Flows x of Annuity at 10% (132,300) 71,500 18,900 8,800 $ 7,900 Net…
Information for two alternative projects involving machinery investments follows. Project 1 requires an initial investment of $135,000. Project 2 requires an initial investment of $98,000. Assume the company requires a 10% rate of return on its investments. (PV of $1. FV of $1, PVA of $1. and FVA of $1) (Use appropriate factor(s) from the tables provided.) Annual Amounts Sales of new product Expenses Materials, labor, and overhead (except depreciation) Depreciation-Machinery Selling, general, and administrative expenses Income Years 1-7 Project 1 Net present value Years 1-5 Compute the net present value of each potential investment. Use 7 years for Project 1 and 5 years for Project 2. (Negative net present values should be indicated with a minus sign. Round your present value factor to 4 decimals. Round your answers to the nearest whole dollar.) Project 2 Net present value Net Cash Flows Net Cash Flows X x Present Value of Annuity at 10% Project 1 $ 100,000 Present Value of Annuity at…
Compare the following two alternatives by the IRR method, given MARR of 6%/year. First find if they are feasible and then compare them with the incremental rate of return (AROR). Alt. Construction cost $ Benefits $/yr Salvage $ Service Life (yrs) A 410,000 55,000 20,000 11 B 250,000 35,000 10,000 11
Net Present Value Method, Internal Rate of Return Method, and Analysis for a Service Company The management of Advanced Alternative Power Inc. is considering two capital investment projects. The estimated net cash flows from each project are as follows: Wind Biofuel Year Turbines Equipment 1 $250,000 $480,000 250,000 480,000 3 250,000 480,000 4 250,000 480,000 The wind turbines require an investment of $713,750, while the biofuel equipment requires an investment of $1,457,760. No residual value is expected from either project. Present Value of an Annuity of $1 at Compound Interest Year 6% 10% 12% 15% 20% 1 0.943 0.909 0.893 0.870 0.833 1.833 1.736 1.690 1.626 1.528 3 2.673 2.487 2.402 2.283 2.106 4 3.465 3.170 3.037 2.855 2.589 4.212 3.791 3.605 3.353 2.991 4.917 4.355 4.111 3.785 3.326 7 5.582 4.868 4.564 4.160 3.605 8 6.210 5.335 4.968 4.487 3.837 9 6.802 5.759 5.328 4.772 4.031 10 7.360 6.145 5.650 5.019 4.192 Required: la. Compute the net present value for each project. Use a rate…
A PROJECT IS ESTIMATED TO COST P 100,000.00, LASTS 8 YEARS, AND HAVE A P 10,000.00 SALVAGE VALUE. THEANNUAL GROSS INCOME IS EXPECTED TO AVERAGE P 24,000.00 AND ANNUAL EXPENSES, EXCLUDINGDEPRECIATION, WILL TOTAL P 6,000.00. IF CAPITAL IS EARNING 10% BEFORE INCOME TAXES, DETERMINE IFTHIS IS A DESIRABLE INVESTMENT USING:A.) RATE-OF-RETURN METHODB.) ANNUAL COST METHODC.) PRESENT-WORTH COST METHOD
Information for two alternative projects involving machinery investments follows. Project 1 requires an initial investment of $130,900. Project 2 requires an initial investment of $97,200. Assume the company requires a 10% rate of return on its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Annual Amounts Sales of new product Expenses Materials, labor, and overhead (except depreciation) Depreciation-Machinery Selling, general, and administrative expenses Income Project 1 Years 1-7 Initial investment Net present value Compute the net present value of each potential investment. Use 7 years for Project 1 and 5 years for Project 2. (Negative net present values should be indicated with a minus sign. Round your present value factor to 4 decimals. Round your answers to the nearest whole dollar.) Net Cash Flows X Answer is complete but not entirely correct. Present Value of Annuity at 10% 26,460 X Project 1 $ 105,300 X 70,200…
Determine the Rate of Return (ROR) for the following project. Initial Capital Investment (P) = $2,942,825 Project Life (n) = 10 years Salvage Value at the end of year 10 $50,000 Equal Annual Revenues = $1,100,000 Equal Annual Operations and Maintenance Costs (AOC) = $400,000 Minimum Acceptable Rate of Return (MARR) = 22% ycy %3D %3D %3D That is the ROR of the project (to the nearest 1%)?
The following are the relevant data of two alternative machines are shown in the table below. Determine which is the better machine if T=40%, a CFAT MARR of 10%, and SL as a depreciation method. What is the depreciation per year? Note: Calculate the CFAT thru tabular method. Use AW for solving.
Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 3 14,420 16,480 21,630 4 14,420 12,360 13,390 5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.)
Two types of power converters are under consideration for a specific application. An economic comparison is to be made using a MARR of 10% and the following cost estimates: Alternative Model A Model B Service Life (Years) 5 10 First Cost $10,000 $20,000 Salvage Value 0 5,000 Annual Operating Cost 2,500 1,200 Draw the Cash Fiow Diagram for each alfernative covering the entire analysis period. Compute the Net Present Worth for Model A? Compute the Net Equivalent Uniform Annual Worth for Model A? Which of these alternatives should be selected?
A concrete vibrating equipment will be purchased for a cost of $107,425. After a useful life of 5 years it is assumed the equipment will be sold for $33,450. Assume interest of 7.5% for borrowing money, 4.3% for risk, and 2.2% as the equivalent interest rate fortaxes, insurance, and storage, Calculate the annual ownership cost and the cost per hour assuming the equipment will be used 1920 hr. /yr.
Information for two alternative projects involving machinery investments follows. Project 1 requires an initial investment of $133,000. Project 2 requires an initial investment of $99,900. Assume the company requires a 10% rate of return on its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Annual Amounts Sales of new product Expenses Materials, labor, and overhead (except depreciation) Depreciation Machinery Selling, general, and administrative expenses Income Years 1-7 Project 1 Net present value Years 1-5 Compute the net present value of each potential investment. Use 7 years for Project 1 and 5 years for Project 2. (Negative net present values should be indicated with a minus sign. Round your present value factor to 4 decimals. Round your answers to the nearest whole dollar.) Project 2 Net present value Net Cash Flows Net Cash Flows X X Present Value of Annuity at 10% Present Value of Annuity at 10% = Project 1…