A Pharma company has recently recruited 4 scientists at an avg age of 27 n is looking to develop quite a few pharmacological formulations.

The no of beneficiaries will be 4 in no.The total cost of purchasing apartments will be Rs.1 cr.PNBHFL offers an 18 year term @ 9.00% interest n HDFC offers 15 years term @ 8% interest.The company will pay the housing finance company on an EAV basis.A Down payment of 5% of the cost of the apartment has to be made and recoverable from the employee in 24 installments. The upfront payment will be made by the company.In the case of availing a loan from HDFC, 50% of the EAV will be recovered from the employee on a monthly basis and in case of availing the loan from PNBHFL 45% will be recovered from the employee. The option of choosing the service rests with the company only.Assume a 6% accrual on the deductions taken from the employee under either option with quarterly compounding.Assume that employee deductions happen on the first day of the month and housing loan payments made by the company happens on the last day of the year.The housing loan is offered on a fixed interest basis and EAV will not change.Assume the individual apartments are of equal value.

PVIFA 18, 9=8.76PVIFA 15, 8 =8.56

Answers required for the belwo qns

a.Calculate the two EAV options and choose the best one.

b.Calculate monthly deduction of each employee under the two options

c.Calculate the accumulated maturity value per year inclusive of compounded quarterly interest.

d.Calculate the EAV differential borne by the company a. on annual basis b. over the tenor.

Need tabulated workings using excel