Suppose your best friend is a doctor, and he is asking for help with the evolution of a possible business, where he would create a medical clinic together with other colleagues.

The proposal is that 3 doctors are going to create a private clinic, where each one will carry their client portfolio, but they hope to consolidate their portfolios and make customers more profitable by giving them different medical specialties in a single location. Together, they should add an initial investment of 45 million colones. Sales for the first 3 years expect to have a monthly average of 5 million per year, the next 3 years the average would be 7.5 million, then 4 years of 10 million and the last 5 years on average of 12.5 million

Each investor will contribute 15 million. Between your savings and what you are going to borrow, your money costs would be 14, 15, and 16.

Run the flow 100 times with each required change. Point out the changes you applied in Excel

What is the weighted cost of the money to evaluate the project?

First change. Place that weighted cost value in the model.

b) What is the average recovery period?

c) How much is the VAN / NPV of the project?

D) How much is the TIR / IRR of the project?

Second change. There is the possibility of adding a laboratory to the clinic, but it would involve the following changes:

1. The initial investment increases by 5 million (modify row 2)

2. The average sales rise by 500,000

e) What is the average recovery period?

f) How much is the VAN / NPV of the project?

g) How much is the TIR / IRR of the project?

h) If I had to borrow the total of about 50 million, does the project's TIR / IRR change?

i) If I had to borrow the total of about 50 million to 20%, and does the VAN / NPV change?