Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started