Question

In: Finance

Given the following information, determine the feasibility of this investment. Veronika has a great idea for...

Given the following information, determine the feasibility of this investment.

Veronika has a great idea for a new online game for mobile devices. The game allows players to destroy alien invaders, which is nothing new, but it also serves as a social engagement app that will allow gamers to connect with other gamers that share their interest, similar to existing dating services. By combining game playing with dating, she thinks she can reach a new market, but she fully expects that others will copy her. Therefore, she assumes that this is a limited time opportunity.

Veronika estimates that it will cost about $175,000 to hire a game engineering contractor to build the app. Once it is built, the engineering firm will receive $0.18 per download as a royalty. The cloud hosting platform firm will charge them $0.12 per month per active user. Veronika will have to spend $25,000 each of the first         two years to market the game. She projects that the game will probably last only about four years, with           downloads and users dropping off after the first two years. There will be no salvage costs (terminal value) after the end of the four years. Downloading the app will cost users $1.99 as a one-time fee. In addition to the   revenue from the downloads, she expects to earn about $0.78 per month per active user in advertising and promotion revenue. Her annual projections for downloads and average monthly users are shown below.

Year

Downloads

Avg Monthly Users

1

250,000

18,750

2

150,000

22,000

3

60,000

12,000

4

30,000

8,000

She also expects to incur $240,000 per year in other operating costs the first year, but that amount should decrease to $200,000 in the second year and then down to $100,000 per year in years three and four.

The $175,000 of development costs are amortized for tax purposes for three years under a special tax incentive law. She can claim 60 percent of the development cost in Year 1, 35 percent in year 2, and the final 5 percent in year 3. The cost of capital to discount the future cash flows is 15 percent, and the average tax rate is 30 percent.

Create a spreadsheet named LastName_FirstName_HW03.xlsx to compute the NPV, IRR, PI, and Payback for this project and interpret the results. You will have to calculate the initial investment at time zero and the after-tax operating cash flows for Years 1 through 4 to calculate the NPV, IRR, PI, and Payback. Remember to convert "monthly" into "annual" when computing revenue and expense per year. After computing the relevant financial metrics, make a recommendation to Veronika and justify that recommendation by citing the information you have generated in your spreadsheet. Set up your spreadsheet so that the instructor can follow your calculations.

Solutions

Expert Solution

Step 1: Calculate After-Tax Operating Cash Flows

The value of annual cash flows is arrived with the use of following table:

Annual After-Tax Operating Cash Flows
0 1 2 3 4
Initial Investment -175,000
Revenue from App Download 497,500 (250,000*1.99) 298,500 (150,000*1.99) 119,400 (60,000*1.99) 59,700 (30,000*1.99)
Advertising and Promotion Revenue 175,500 (18,750*12*.78) 205,920 (22,000*12*.78) 112,320 (12,000*12*.78) 74,880 (8,000*12*.78)
Total Revenue (A) 673,000 504,420 231,720 134,580
Less Costs/Expenses:
Royalty Fees 45,000 (250,000*.18) 27,000 (150,000*.18) 10,800 (60,000*.18) 5,400 (30,000*.18)
Hosting Fees 27,000 (18,750*12*.12) 31,680 (22,000*12*.12) 17,280 (12,000*12*.12) 11,520 (8,000*12*.12)
Marketing Costs 25,000 25,000 0 0
Operating Costs 240,000 200,000 100,000 100,000
Amortization of Development Costs 105,000 (175,000*60%) 61,250 (175,000*35%) 8,750 (175,000*5%) 0
Total Costs (B) 442,000 344,930 136,830 116,920
EBT (A-B) 231,000 159,490 94,890 17,660
Less Taxes (EBT*30%) 69,300 47,847 28,467 5,298
EAT 161,700 111,643 66,423 12,362
Add Amortization of Development Costs 105,000 61,250 8,750 0
After-Tax Operating Cash Flow -$175,000 $266,700 $172,893 $75,173 $12,362

_____

Step 2: Calculate NPV

NPV is the difference between the present value of cash inflows and outflows. It can be calculated with the use of following formula:

NPV = Cash Flow Year 0 + Cash Flow Year 1/(1+Cost of Capital)^1 + Cash Flow Year 2/(1+Cost of Capital)^2 + Cash Flow Year 3/(1+Cost of Capital)^3 + Cash Flow Year 4/(1+Cost of Capital)^4

The NPV has been calculated as follows:

0 1 2 3 4
Initial Investment -175,000
Revenue from App Download 497,500 298,500 119,400 59,700
Advertising and Promotion Revenue 175,500 205,920 112,320 74,880
Total Revenue (A) 673,000 504,420 231,720 134,580
Less Costs/Expenses:
Royalty Fees 45,000 27,000 10,800 5,400
Hosting Fees 27,000 31,680 17,280 11,520
Marketing Costs 25,000 25,000 0 0
Operating Costs 240,000 200,000 100,000 100,000
Amortization of Development Costs 105,000 61,250 8,750 0
Total Costs (B) 442,000 344,930 136,830 116,920
EBT (A-B) 231,000 159,490 94,890 17,660
Less Taxes (EBT*30%) 69,300 47,847 28,467 5,298
EAT 161,700 111,643 66,423 12,362
Add Amortization of Development Costs 105,000 61,250 8,750 0
After-Tax Operating Cash Flow (C) -175,000 266,700 172,893 75,173 12,362
PVIF (D) 1 0.8696 [1/(1+15%)^1] 0.7561 [(1/(1+15%)^2] 0.6575 [1/(1+15%)^3] 0.5718 [1/(1+15%)^4]
Present Value of Cash Flows (C*D) -175,000 231,913 130,732 49,427 7,068
NPV $244,140.47

_____

Step 3: Calculate IRR

IRR is the minimum rate of return acceptable from a project. IRR can be calculated with the use of IRR function of EXCEL/Financial Calculator. The basic formula for calculating IRR is given as below:

NPV = 0 = Cash Flow Year 0 + Cash Flow Year 1/(1+IRR)^1 + Cash Flow Year 2/(1+IRR)^2 + Cash Flow Year 3/(1+IR)^3 + Cash Flow Year 4/(1+Cost of Capital)^4

IRR is calculated with the use of EXCEL as below:

where IRR = IRR(B17:F17) = 109.96%

_____

Step 4: Calculate Profitability Index

The value of profitability index is determined as follows:

Profitability Index = Present Value of Cash Inflows/Initial Investment

where Present Value of Cash Inflows = Cash Flow Year 1/(1+Cost of Capital)^1 + Cash Flow Year 2/(1+Cost of Capital)^2 + Cash Flow Year 3/(1+Cost of Capital)^3 + Cash Flow Year 4/(1+Cost of Capital)^4

The profitability index is calculated with the use of table given below:

Annual Cash Flows
0 1 2 3 4
Initial Investment -175,000
Revenue from App Download 497,500 298,500 119,400 59,700
Advertising and Promotion Revenue 175,500 205,920 112,320 74,880
Total Revenue (A) 673,000 504,420 231,720 134,580
Less Costs/Expenses:
Royalty Fees 45,000 27,000 10,800 5,400
Hosting Fees 27,000 31,680 17,280 11,520
Marketing Costs 25,000 25,000 0 0
Operating Costs 240,000 200,000 100,000 100,000
Amortization of Development Costs 105,000 61,250 8,750 0
Total Costs (B) 442,000 344,930 136,830 116,920
EBT (A-B) 231,000 159,490 94,890 17,660
Less Taxes (EBT*30%) 69,300 47,847 28,467 5,298
EAT 161,700 111,643 66,423 12,362
Add Amortization of Development Costs 105,000 61,250 8,750 0
After-Tax Operating Cash Flow -175,000 266,700 172,893 75,173 12,362
PVIF 0.8696 0.7561 0.6575 0.5718
Present Value of Cash Inflows 231,913 130,732 49,427 7,068
Total Present Value of Cash Inflows (D) 419,140
Initial Investment (E) 175,000
Profitability Index (D/E) 2.40

_____

Step 4: Determine Payback Period

Payback period is the period within the initial investment is recovered with the use of after-tax operating cash flows. As the value of initial investment is less than the after-tax operating cash flow for the year, we can conclude that the payback period is less than 1 Year.The exact value of payback period is calculated as below:

Payback Period = Initial Investment/After-Tax Operating Cash Flow for Year 1 = 175,000/266,700 = .66 or 7 months

_____

Step 5: Recommendation

Veronika should invest in the project as it results in a positive NPV. Also, the internal rate of return is greater than the cost of capital and profitability index is greater than 1. Not only that, the total amount invested by Veronika gets recovered in the first year itself. Therefore, it is an ideal project for investment.


Related Solutions

Given the following information, determine the feasibility of this investment. Veronika has a great idea for...
Given the following information, determine the feasibility of this investment. Veronika has a great idea for a new online game for mobile devices. The game allows players to destroy alien invaders, which is nothing new, but it also serves as a social engagement app that will allow gamers to connect with other gamers that share their interest, similar to existing dating services. By combining game playing with dating, she thinks she can reach a new market, but she fully expects...
Everyone has a great idea, at least they think that their ideas are great! How does...
Everyone has a great idea, at least they think that their ideas are great! How does a great idea differ from a great opportunity? Explain.
Discuss how you will make the following feasibility analysis on the business idea ( production of...
Discuss how you will make the following feasibility analysis on the business idea ( production of face shield) i) concept testing ii) Usability testing
Use the information in the following table, and information given on imports and exports, to determine...
Use the information in the following table, and information given on imports and exports, to determine the level of unplanned inventory at each level of real GDP. Employment, Output, Consumption, and Unplanned Inventory Possible Levels of Employment Real GDP (Output) Equals Disposable Income Consumption Investment Unplanned Inventory (Millions of workers) (Billions of dollars) (Billions of dollars) (Billions of dollars) (Billions of dollars) 40 325 300 150 45 375 325 150 50 425 350 150 55 475 375 150 60 525...
THIS IS ALL THE INFORMATION GIVEN TO DETERMINE THE SOLUTIONS: The following are two years of...
THIS IS ALL THE INFORMATION GIVEN TO DETERMINE THE SOLUTIONS: The following are two years of income statements and balance sheets for the Munich Exports Corporation. MUNICH EXPORTS CORPORATION BALANCE SHEET 2009 2010 Cash $   50,000 $   50,000 Accounts Receivable 200,000 300,000 Inventories 450,000 570,000 Total Current Assets 700,000 920,000 Fixed Assets, net 300,000 380,000 Total Assets 1,000,000 1,300,000 Accounts Payable 130,000 180,000 Accruals 50,000 70,000 Bank Loan 90,000 90,000 Total Current Liabilities 270,000 340,000 Long-Term Debt 400,000 550,000 Common...
- Given the following information, determine the beta coefficient for Stock L that is consistent with...
- Given the following information, determine the beta coefficient for Stock L that is consistent with equilibrium: = 9.5%; rRF = 2.5%; rM = 11.5%. - You have been managing a $5 million portfolio that has a beta of 1.05 and a required rate of return of 11.925%. The current risk-free rate is 3%. Assume that you receive another $500,000. If you invest the money in a stock with a beta of 1.35, what will be the required return on...
Swindler Ltd has completed a feasibility study costing $18,244to determine if there is any benefit...
Swindler Ltd has completed a feasibility study costing $18,244 to determine if there is any benefit in purchasing a new asset. The machine will cost $378,340 and an additional $11,277 will need to be spent to have the machine in an operational state. Before the machine can be used staff must be trained at a further cost of $7,308.The project is expected to last for 5 years and the Taxation Office has confirmed this. At the end of the project,...
Swindler Ltd has completed a feasibility study costing $22652 to determine if there is any benefit...
Swindler Ltd has completed a feasibility study costing $22652 to determine if there is any benefit in purchasing a new asset. The machine will cost $298115 and an additional $21316 will need to spent to have the machine in operational state. Before the machine can be used staff must be trained at a further cost of $6239. The project is expected to last for 5 years and the Taxation Office has confirmed this. At the end of the project the...
Swindler Ltd has completed a feasibility study costing $16769 to determine if there is any benefit...
Swindler Ltd has completed a feasibility study costing $16769 to determine if there is any benefit in purchasing a new asset. The machine will cost $318900 and an additional $14152 will need to spent to have the machine in operational state. Before the machine can be used staff must be trained at a further cost of $9602. The project is expected to last for 5 years and the Taxation Office has confirmed this. At the end of the project the...
Given the following information, you are to determine the following Project network. Early, late and slack...
Given the following information, you are to determine the following Project network. Early, late and slack activity times. Project duration. Critical path Task Predecessor Duration A None 5 B A 8 C A 15 D A 10 E A 10 F B 10 G C, D 12 H E, 15 I G, H 7 J F,G,I 10 K J 12
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT