Question

In: Finance

please answer the question by explaining the step by step process used in the calculation. and...

please answer the question by explaining the step by step process used in the calculation. and please discuss the results. thank you:)

Please set-up solution model for the following capital budget problem. Explain the approach you plan to take and why. Then, please perform the calculations of your model and draw conclusions.

Capital Budget Problem:

This case continues following the new project of the WePPROMOTE Company, that you and your partner own. WePROMOTE is in the promotional materials business. The project being considered is to manufacture a very unique case for smart phones. The case is very durable, attractive and fits virtually all models of smart phone. It will also have the logo of your client, a prominent, local company and is planned to be given away at public relations events by your client.

More details have emerged and your estimates are becoming more precise.

The following are the new values to the data that you have been estimating up to this point:

  • You can borrow funds from your bank at 3%.
  • The cost to install the needed equipment will be $105,000 and this cost is incurred prior to any cash is received by the project.
  • The gross revenues from the project will be $25,000 for year 1, then $27,000 for years 2 - 4. Year 5 will be $23,000.
  • The expected annual cash outflows (current project costs) are estimated at being $13,000 for the first year, then $12,000 for years 2, 3, and 4. The final year costs will be $10,000.
  • After 5 years the equipment will stop working and will be worthless.
  • The discount rate you are assuming continues to be 6%.

Calculate the net present value, and determine whether the project is worth doing from a financial perspective.

Solutions

Expert Solution

To solve a capital budgeting problem, we need to calculate net cash inflows from the project during the project life cycle. Net cash inflow is equal to the cash inflows minus cash outflows.

After calculation of net cash inflows, we need to discount it at appropriate rate to find out present value of the cash flows. Discount rate in the given question is 6%. We need to figure out the discounting factors using the appropriate discount rate. Formula to calculate discounting factor is (1+discount rate)^n. Where, n is the year for which we are calculating discount rate. Suppose discount rate is 6% and we need to calculate discounting factor for year 5. Then discounting factor for year 5 = (1+0.06)^5= 1.3382256.

After calculating the discounting factor, we need to divide the net cash outflows by the discounting factor to get present value of all the future cash flows.

When we add all the present value of future cash flows, we get the Net Present Value(NPV) of the Project.

If NPV>0, then project should be accepted, else, project should not be accepted. The given problem is calculated as below. We assumed that bank interest on initial cash outlay of $105000 @3% is paid equally using simple interest and no repayment of loan made during the project life.

Since the NPV of the Project is negative, we should not accept this project.


Related Solutions

Segment profitability Calculation (Please show both the calculation process and the final answer) Q1 What is...
Segment profitability Calculation (Please show both the calculation process and the final answer) Q1 What is the margin ($ dollar value) of each segment (experientials, indulgents and frugals) per customer per year for Red Lobster according to the table below? (hint: food margin($)for each customer+ alcohol margin($)for each customer) Q2 Which segment is the most profitable and should be target at according to results in Q1? Q3 Calculate each segment’s total margin change ($) if Red Lobster gain 2000 new...
Please provide an elaborate answer explaining every single step The price of a stock is $40....
Please provide an elaborate answer explaining every single step The price of a stock is $40. The price of a one-year put with strike price $30 is $0.70 and a call with the same time to maturity and a strike of $50 costs $0.50. Both options are European. (a) An investor buys one share, shorts one call and buys one put. Draw and comment upon the payoff of this portfolio at maturity as a function of the underlying price. (b)...
I was wondering if I could get a step by step process to answer this question?
I was wondering if I could get a step by step process to answer this question?
And please show me the step by step process of how you solved the question. I...
And please show me the step by step process of how you solved the question. I have a learning disability and I need to know the steps to solve the question If it takes 17.5 mL of 0.085 M NaOH to titrate a 15 mL sample of sauerkraut juice, what is the acidity of that juice, expressed as % lactic acid (wt/vol)?
Please answer the last step for question 1. Answer it asap please. Thanks 1. Consider the...
Please answer the last step for question 1. Answer it asap please. Thanks 1. Consider the following data for three different samples from three different populations:Consider the following data for three different samples from three different populations: Sample 1 Sample 2 Sample 3 0 6 6 4 8 5 0 5 9 1 4 4 0 2 6 T = 5 T = 25 T = 30 G = 60 SS = 12 SS = 20 SS = 14 ∑X2...
Please write the calculation step by step! ------- The Dutch West India Company dispatched the first...
Please write the calculation step by step! ------- The Dutch West India Company dispatched the first permanent settlers to Manhattan Island in 1624. In 1626, the fledgling town's governor, Peter Minuit, bought Manhattan from the Canarsie tribe for $24 worth of beads and trinkets. Locals sometimes cite this transaction as one of the last real estate bargains in New York. • How big of a bargain was it? At 6% interest rate? At 7%?
Please give me step by step answer how to solve this question: Consider the following example....
Please give me step by step answer how to solve this question: Consider the following example. In a study reported in the California Journal of Nursing, nurses were asked to report their degree of job-related stress. They were asked 20 questions about their work and they responded on a 1-5 scale as the amount of stress they felt (5 being the most). These responses were added up in order to come up with a numeric measure of job stress. Below...
Can you please answer the question in an excel with the calculation if possible. T&J manufacturing...
Can you please answer the question in an excel with the calculation if possible. T&J manufacturing has a factory that produces custom kitchen cabinets. It has multiple product lines. Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will assume the following average costs. The materials include $1,000 for the wood and other direct materials of $200. Both items listed are on a per job basis. It requires 20 hours of labor on...
*Please provide step-by-step answer* Question: A researcher is interested  in the relationship between birth order and personality....
*Please provide step-by-step answer* Question: A researcher is interested  in the relationship between birth order and personality. A sample of n=100 people is obtained, all of whom grew up in families as one of three children. Each person is given a personality test, and the researcher also records the person's birth-order position (1st born, 2nd born, or 3rd). The frequencies from this study are shown in the following table. Birth Position 1st 2nd 3rd Outgoing 13 31 16 Reserved    17...
Please, Answer all parts( a,b,c,d) in Question 1 and step by step. Also, by word document...
Please, Answer all parts( a,b,c,d) in Question 1 and step by step. Also, by word document or by keyboard 1. Given below are a set of foreign exchange quotes for several currencies against the Australian dollar as of August 5, 2020. Australian Dollar Exchange Rates Currency Sell/buy US, dollar 0.7143/0.7143 UK, pound 0.5458/0.5459 China, yuan Renminbi 4.9872/4.9907 Hong Kong, dollar   5.5349/5.5364 India, rupee 53.572/53.669 Japan, yen   75.70/75.70 Malaysia, ringgit 3.0104/3.0139 Philippines, peso   34.953/35.135 South Africa, rand 12.2272/12. 2340 Switzerland, franc  ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT