HomeworkLib
Question

Semih has an ambitious growth plan and has put together the following profit pro ections exit the business by selling his shares back to Semih for 500,000 TL. Report the NPV for the investor, using a 12% ROI Report the IRR for the investor see below). For 10 years, the investor will take 30% of the annual profits. After 10 years, the investor will b) Profit Projections Year 100,000.00 125,000.00 156,000.00 195,000.00 244,000.00 305,000.00 381,000.00 77,000.00 96,000.00 745,000.00 1 4 8 10İnitial investment is 500.000. Can you show the solution on excel?

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Requirement-(a EXCEL SCREENSHOT (b)-(a)x30% (u)-(a)-(b u) x (v 1 Requirement-a Net Cash PV Factor Present Year Profit Tax @ 30% Flow @12% Value b)-(a)x30% (u) x (v PV Factor @12% 1.00000 -B/(1+12%) -4/(1+12%) -5/(1+12%) 0 Year Profit Tax @ 30% Net Cash Flow 500,000 100,000 30,000 125,000 37,500 156,000 46,800 195,000 58,500 244,000 73,200 305,000 91,500 213, 500,000 1.00000 -500,000.00 Value :03ЕЗ 70,000 0.89286 62,500.00 87,500 0.79719 69,754.46 109,200 0.71178 77,726.40 136,500 0.63552 86,748.22 170,800 0.56743 96,916.51 500 0.50663 108,165.74 381,000 114,300 266,700 0.45235 120,641.54 333,900 0.40388 134,856.61 596,000 178,800 417,200 0.36061 150,446.50 1,021,500 0.32197 328,895.66 Net Present Value (NPV) 736,651.65 500,000 100,000 125,000 156,000 195,000 244,000 305,000 2 -8430% -85°30% -8630% -8730% 弌8*3096 930% :810°30% :811*30% -812*30% B5-C5 D5E5 4 /(1+12%) /(1+12%) -B7-C7 -B/(1+12%) -P/(1+12%) E10/( 1 +12%) E11/( 1+1296) _E12/(1+12%) 477,000 143,100 12 7 13 8 14 9 15 10 Ref: Workings 16 B10-C10 B11-C11 B12-C12 -745000(1-30%)+500000 D10 E10 -D11 E11 D12 E12 D13E13 477,000 596,000 10 Ref: Workings - - Net Present Value (NPV)SUM(F3:F13)

0 0
Add a comment
Know the answer?
Add Answer to:
İnitial investment is 500.000. Can you show the solution on excel? Semih has an ambitious growth...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Part2 Option No. 2-Investor Capital Semih has found an investor who is willing to provide him...

    Part2 Option No. 2-Investor Capital Semih has found an investor who is willing to provide him with 500,000 TL in exchange for 30% ownership, which means he will take 30% of the annual profits. The investor generally seeks a 12% ROI for his investments. Let's say Semih anticipates that he will have future profits of 200,000 TL peryear for the forseeable future. What is the Present Value of the investment for the investor? Based on the investment amount, what is...

  • Financing Instead of paying rent, UniVEND is consider purchasing several vending machines and operating them personally....

    Financing Instead of paying rent, UniVEND is consider purchasing several vending machines and operating them personally. To do this, Semih needs 500,000 TL in capital. Help Semih determine the best financing option for his business. Pts Part1 Option No. 1- Bank Loarn Answers Kar Bank has a special offer for SMEs, offering a 4-year loan at 1.1% monthly interest rate, payments made at the beginning of the period What are the monthly payments if Semih borrows 500,000 TL? How much...

  • Please only part 1)section 2 a.b and c. Also part 2) section 3 a,bic please it...

    Please only part 1)section 2 a.b and c. Also part 2) section 3 a,bic please it is needed please solve Financing Instead of paying rent, UniVEND is consider purchasing several vending machines and operating them personally. To do this, Semih needs 500,000 TL in capital. Help Semih determine the best financing option for his business Part1 Option No. 1- Bank Loan Kar Bank has a special offer for SMEs, offering a 4-year loan at 1.1% What are the monthly payments...

  • Total 500.000 Can you show the solution on the excel? Semih also spoke with a friend...

    Total 500.000 Can you show the solution on the excel? Semih also spoke with a friend of his who works at Güneş Bank and he received the following offer monthly payments of 10,000 TL at a 1.05% monthly interest rate, followed by a lump sum payment of 60,000 TL at the end of the term. Payments are made at the end of the period. What is the total term of the loan? Give your answer in terms of months a)...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT