Business, 28.07.2021 17:40 vdirectioner7634

The information you hand to Mary shows the following: Initial investment outlay of $30 million, consisting of $25 million for equipment and $5 million for net working capital (NWC) (plastic substrate and ink inventory); NWC recoverable in terminal year
Project and equipment life: 5 years
Sales: $25 million per year for five years
Assume gross margin of 60% (exclusive of depreciation)
Depreciation: Straight-line for tax purposes
Selling, general, and administrative expenses: 10% of sales
Tax rate: 35%
You continue your conversation.
"It looks good," says Mary. "Use this information from Luke and James to compute the cash flows for the project."
"No problem," you say.
"Then, compute NPV and IRR of the project using the Attached Excel spreadsheet I sent earlier today," says Mary. "Use the IRR financial function for the computation of IRR."
"Okay," you say. "I’ll submit my Excel file showing the computation of cash flows, NPV, and IRR by the end of week so you can look at it over the weekend."
"Thanks," says Mary.

Additional Info:
NWC Recapture is in the fifth year.
NWC is given in task list.
The discount rate is given. It is WRONG. Replace it with a 10% discount rate.
A hint: the numbers will look the same for all five years, except for the total cash flow. Year 5 will be different due to NWC recovery.
Sales are given (This is also called Revenue)
Gross margin is given
Calculate: COGS (You must find the equation that gives you COGS from gross margin and sales (revenue))
Subtract from Sales
Calculate
SGA expense
Subtract these from Sales
This gives Gross Profit.
Calculate yearly depreciation, straight line for tax purposes, look this up.
Subtract this from Gross Profit.
This gives EBT, Earnigs Before Taxes
Calculate Taxes on basis of EBT, tax rate is given.
Subtract this from EBT
This gives Net Income
Add Depreciation back in to Net Income
Add NWC recovery to Net Income in the 5th year.
This gives a Cashflow for each year.
Put this into your spreadsheet. The NPV and IRR should calculate automatically. If it does not you have made a mistake.

Answers: 2

Show answers

Another question on Business

Business, 21.06.2019 15:30

Walter wants to deposit $1,500 into a certificate of deposit at the end of each ofthe next 6 years. the deposits will earn 5 percent compound annual interest. ifwalter follows through with his plan, approximately how much will be in his accountimmediately after the sixth deposit is made?

Answers: 1

Answer

Business, 21.06.2019 21:30

Gino's restaurant is a popular restaurant in boston, massachusetts. the owner of the restaurant has been trying to better understand costs at the restaurant and has hired a student intern to conduct an activity-based costing study. the intern, in consultation with the owner, identified the following major activities: activity cost pool activity measure serving a party of diners number of parties served serving a diner number of diners served serving drinks number of drinks ordered some costs, such as the cost of cleaning the linens that cover the restaurant's tables, vary with the number of parties served. other costs, such as washing plates and glasses, depends on the number of diners served or the number of drinks served. data concerning these activities are shown below. serving a party serving a dinner serving drinks total total cost $47,600 $153,000 $59,800 $260,400 total activity 7,000 parties 30,000 diners 46,000 drinks prior to the activity-based costing study, the owner knew very little about the costs of the restaurant. she knew that the total cost for the month was $260,400 and that 30,000 diners had been served. therefore, the average cost per diner was $8.68.required: 1. compute the activity rates for each of the three activities 2. according to the activity-based costing system, what is the total cost of serving each of the following parties of diners? a. a party of four diners who ordered three drinks in total b. a party of two diners who do not order any drinks c. a lone diner who orders two drinks 3. convert the total costs you computed in part (1) above to costs per diner. in other words, what is the average cost per diner for serving each of the following parties: a. a party of four diners who order three drinks in total b. a party of two diner who do not order any drinks c. a lone diner who orders two drinks 4. why do the costs per diner for the three different parties differ from each other and from the overall average coast of $9.80 per diner?

Answers: 1

Answer

Business, 22.06.2019 07:30

What is the relationship between the national response framework and the national incident management system (nims)? a. the national response framework replaces the nims, which is now obsolete. b. the response protocols and structures described in the national response framework align with the nims, and all nims components support response. c. the nims relates to local, state, and territorial operations, whereas the nrf relates strictly to federal operations. d. the nims and the national response framework cover different aspects of incident managementâ€”the nims is focused on tactical planning, and the national response framework is focused on coordination.

Answers: 3

Answer

Business, 22.06.2019 08:40

Calculate the cost of each capital component—in other words, the after-tax cost of debt, the cost of preferred stock (including flotation costs), and the cost of equity (ignoring flotation costs). use both the capm method and the dividend growth approach to find the cost of equity.calculate the cost of new stock using the dividend growth approach.what is the cost of new common stock based on the capm? (hint: find the difference between re and rs as determined by the dividend growth approach and then add that difference to the capm value for rs.)assuming that gao will not issue new equity and will continue to use the same target capital structure, what is the company’s wacc? e. suppose gao is evaluating three projects with the following characteristics.each project has a cost of $1 million. they will all be financed using the target mix of long-term debt, preferred stock, and common equity. the cost of the common equity for each project should be based on the beta estimated for the project. all equity will come from reinvested earnings.equity invested in project a would have a beta of 0.5 and an expected return of 9.0%.equity invested in project b would have a beta of 1.0 and an expected return of 10.0%.equity invested in project c would have a beta of 2.0 and an expected return of 11.0%.analyze the company’s situation, and explain why each project should be accepted or rejected g

Answers: 1

Answer

You know the right answer?

The information you hand to Mary shows the following: Initial investment outlay of $30 million, con...

Questions