Question

# The Halls Gap Wildlife Park offers a unique Australian wildlife experience. The park offers a scenic...

Q. Need to prepare financial analysis (npv, roi and payback figures) , budget estimate (cost model and baseline) ,schedule estimate including work breakdown structure level 3 IN AN EXCEL SHEET.

1. Financial Analysis

a. NPV - Net Present Value - PNV gives the present value of the future cash flows.

 Year 0 1 2 3 Estimated Cash Outflow -100000 -10000 -10000 -6000 Estimated Cash Inflow - 70000 100000 145000 Net Cash Flow -100000 60000 90000 139000

Discout rate given - 6 %

Using NPV Formula -

NPV = \$ 144,727

b. ROI - Return on Investment

Total Investment made in three year = \$126,000

Total expected gain in three years = \$145,000

ROI = Profits/Cost of Investment = \$189,000/\$126,000

RIO = 50%

 Year Estimated Cash Outflow Estimated Cash inflow Cumulative Cash Flow 0 -100000 - -100000 1 -10000 70000 -40000 2 -10000 100000 50,000 3 -6000 145000

Payback period is 2 years.

Taking a gander at the NPV, ROI and Payback period, the undertaking is giving impressive returns than the normal ought to be taken up for the venture.

2. Spending Estimates for the Application Development -

Venture Manager - 01 no's

Working Schedule - one day in seven days

Working hours - 8 hrs.

Working hours in seven days = 8 hrs.

All out working hours for 12 weeks = 8*12 = 96 hrs.

Rate - \$100 per hrs.

All out Cost of Project Manager = 96*100 = \$9600

Group = 3 no's

Working Schedule = 5 days in seven days

Working hours in a day = 8 hrs.

All out working hours in 12 weeks = 8*5*12 = 4800

All out working long periods of group = 4800*3 = 1440

Rate = 70 for every/hrs.

All out Cost of the group = 1440*70= \$100,800

All out cost (Project Manager + Team)= \$9600+\$100,800 = \$110,400

Spending plan gave = 126,000

Consultant cost and contact cost can be made do with balance accessible spending plan.

3. Scheduled Estimates and Work Breakdown structure

Week 1 - Requirement gathering

Week 2 - Understanding activities and show up at work process or cycle stream to join in the application

Week 3 and 4 - Analysis

Week 5,6,7 and 8 - Coding

Week 9 and 10 - Testing

Week 11 - Alfa and Beta adaptation of the application

Week 12 - Roll out

#### Earn Coins

Coins can be redeemed for fabulous gifts.