Question: Develop an Excel spread sheet for the following problem. Calculate the Present Value Net Benefits (PVNB), the Benefit-to-Cost and Savings-to-Investment Ratios (BCR and SIR). State
Develop an Excel spread sheet for the following problem. Calculate the Present Value Net Benefits (PVNB), the Benefit-to-Cost and Savings-to-Investment Ratios (BCR and SIR). State whether the project is economic or not. N.B: consider all benefits, profits etc to be positive and all costs, investments etc to be negative.
Question 2 Consider a project to builda new junior high school, needed because of increased population growth. Information for the project is as follows: Building first costs (design, planning and construction) $10,000,000 Initial cost for roadway and parking facilities $5,500,000 First cost to equip and furnish facility $500,000 Annual operating and maintenance costs $350,000 Annual savings from rented space $500,000 Annual benefits to community 1,500,000 Interest rate 12%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
