Please show me how to do the following in excel. An additional "show formulas" would also...

Please show me how to do the following in excel. An additional "show formulas" would also be helpful.

NOK Plastics is considering the acquisition of a new plastic injection-molding machine to make a line of plastic fittings. The cost of the machine and dies is $125,000. Shipping and installation is another $8,000. NOK estimates that new project will require $7,500 in inventory, and result in a $7,500 increase in accounts receivable and a $5,000 increase in accounts payable. The latter three will be recovered at the end of the life of the equipment.

Sales of the new plastic fittings are expected to be $350,000 annually. Cost of goods sold are expected to be 50% of sales. Additional operating expenses are projected to be $115,000 per year over the machine’s expected 5-year useful life. The machine will depreciated using a 5-year MACRS class life. The equipment will be sold at the end of its useful life (5 years) for $35,000.

The tax rate is 25% and the relevant discount rate is 15%.

Calculate the following:

net present value (NPV)
Internal rate of return (IRR)
Payback period (PB)
Profitability index (PI)

State whether the project should be accepted.

Expert Solution

jeff jeffy answered 1 year ago

Can someone do this in Excel and show me the formulas as well. The management of...

Can someone do this in Excel and show me the formulas as well. The management of Tri-County Air Taxi, Inc., is considering the replacement of an old machine used in its helicopter repair facility. It is fully depreciated but it can be used by the corporation through 20x5. If management decides to replace the old machine, James Transportation Company has offered to purchase it for $69,000 on the replacement date. The old machine would have no salvage value in 20x5....

Please show how to write the formulas for these in Excel. That is what the assignment...

Please show how to write the formulas for these in Excel. That is what the assignment requires and I don't know how to do it. Thank you! All are in column D. Cell numbers that matter are noted on the left. Suppose the risk-free interest rate is 4%. a. Having $200 today is equivalent to having what amount in one year? b. Having $200 in one year is equivalent to having what amount today? c. Which would you prefer, $200...

please show me how to do this using excel and its functions A proposed overseas expansion...

please show me how to do this using excel and its functions A proposed overseas expansion has the following cash flows: Year Cash Flow 0 -$200 1 50 2 60 3 70 4 200 Calculate the payback, the internal rate of return, the NPV, the profitability index, and the modified IRR at a cost of capital of 10%.

Please show me how to do this by using excel and its functions Mrs. Dawn Chorus,...

Please show me how to do this by using excel and its functions Mrs. Dawn Chorus, founder and president of United Bird Seed, is wondering whether the company should make its first public sale of common stock and, if so, at what price. The company’s financial plan suggests rapid growth over the next three years but only moderate growth afterwards. Forecasted dividends per share are as follows: Year 1 2 3 4 5 $1.00 $1.20 $1.44 ...

Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes...

Please show me how to do this with Excel QM, not Solver. Astro Winter LLC makes snowplowing equipment. The company buys the engines from a 3rd party vendor – Marshall Engines. Astro Winter has the following production schedule for February, March, April, and May: February – 60; March – 85; April 100; May – 120. Marshall Engines makes and delivers the products to Astro Winter during the month the engines are due. Marshall Engines can only manufacture 40 engines in...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...

PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...

For Networks -> Please show me how to do the following: a.) Calculate the CRC of...

For Networks -> Please show me how to do the following: a.) Calculate the CRC of a signal given a generating function and a # of bits to add. b.) Calculate the checksum of a signal.

For Networks -> Please show me how to do the following: a.) Calculate the parity of...

For Networks -> Please show me how to do the following: a.) Calculate the parity of a signal. b.) Calculate the parity of a signal using interleaving.

Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($...

Can you do in excel please and show the formulas Lunar Motivation Corporation Income Statement ($ in millions) 2019 Sales 8000 Cost of Goods -5600 SGA -1500 Interest -100 EBT 800 Taxes (40%) -320 Net income 480 Dividends -100 Retained earnings 380 ==== Lunar Motivation Corporation Balance Sheet 2019 2019 Cash 10 Accounts payable 300 Accounts receivables 400 Notes payable 300 Inventory 560 Current liabilities 600 Short term Investments 30 Long-term debt 1000 Current assets 1000 Common stock 400 Net plant & equip. 3000 Retained earnings 2000 Total assets 4000 Total liab. & equity 4000 ===== ===== You have forecasted Lunar Motivation Corporation (LMC) free cash flow in 2020 to be...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected...

USE EXCEL ONLY AND SHOW FORMULAS PLEASE! An office building is purchased with the following projected cash flows: • NOI is expected to be $130,000 in year 1 with 5 percent annual increases. • The purchase price of the property is $720,000. • 100 percent equity financing is used to purchase the property. • The property is sold at the end of year 4 for $860,000 with selling costs of 4 percent. • The required unlevered rate of return is...

Question