Question: In the attached Excel spreadsheet, complete the private equity fund cash flows and calculate the following. Assume the cash flows are for a Primary Fund

In the attached Excel spreadsheet, complete the private equity fund cash

In the attached Excel spreadsheet, complete the private equity fund cash flows and calculate the following. Assume the cash flows are for a Primary Fund Commitment deal, with a Make-Whole provision for LPs (i.e. LP capital is paid back first before the GP can receive any distributions). The management fee is 2% per year based on the committed capital and the profits are distributed in an 80/20 split to LPs and GP. Calculate the following and show the work in Excel:

Cash flows to LPs

Cash flows to GP

SI-IRR for LPs

Net TVPI to LPs

NPV to LPs (assuming a 15% discount rate)

NPV Income to GPs (assuming a 15% discount rate)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Case: Replacement Decisions Falconville Pump Company, Inc. Brandon Joiner, president and chief executive officer of Falconville Pump Company, Inc., has a potentially serious problem on his hands. The...

Answer Doc for 2 looks like this below Case: Replacement Decisions Falconville Pump Company, Inc. Brandon Joiner, president and chief executive officer of Falconville Pump Company, Inc., has a...

I need to get help with this case study PwC Case Studies in Taxation, 2013, PwC, LLP FLATIRONS, INC. Flatirons, Inc. (dba Flatirons Flapjacks Caf) specializes in unique breakfast and brunch menus and...

Hi I know you opted out of an earlier question. I have several open questions. I really need to get them in. Would you be willing to take any of these questions? I have been waiting for 3 days. I...

Hello!! I want to make sure I am on the right track with this!! The professor is no help, my fellow students are lost, and I want to make sure I am handing in something that makes sense otherwise the...

Can you please help me with this question? ref Hawaiian PwC Case Studies in Taxation, 2013, PwC, LLP HAWAIIAN MEMORIES, INC. Hawaiian Memories, Inc. (HMI) is a C corporation that was formed in 2007...

Can you please help me with this question Bearden PwC Case Studies in Taxation, 2013, PwC, LLP BEARDEN'S SPECIALTY PRODUCE, INC. Your client, Frank Bearden, owns an Arkansas business that brokers...

I need help with the 3 questions in the excel file attached on Capital Budgeting. I also attached the case study for reference. Any help would be greatly appreciated! HBSP Product Number TCG 3 THE...

Hi, I need help with the attached Excel spreadsheet. There are multiple questions across the different tabs. Please do not claim this unless you have read the questions and you are positive you can...

A caving operation is conducted in a relatively weak rock mass where the joint persistence is 88%. Laboratory testing of intact core shows that Co = 88 MPa, and = 29. Specific weight of rock is...

Izhar wants to buy a house in Taman Fulawa. The market price of the house is RM500,000. He is interested to get an Islamic home financing through Bank Hasan. There are two types of home financing...

15. Crater Lake, the deepest lake in the United States, was caused by a huge volcanic eruption 7700 years ago. Since human beings have lived around the mountain for more than 10,000 years, it is...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...