Question: please explain on excel. please show formulas for excel Question 30 0/2 points A new project will cost $100,000. It will increase sales by 80,000

please explain on excel. please show formulas for excel

Question 30 0/2 points A new project will cost $100,000. It will increase sales by 80,000 units but will also increase annual fixed costs by $15,000. Selling price per unit is $8.50 and variable cost per unit is $7.50. The project will also require initial investment of $20,000 in net working capital. The project will last for three years, and depreciation will be straight-line to zero. Interest expense will be $5,000. Given that the required rate of return on this project is 16%, and the marginal corporate tax rate is 40%, what is the net present value of this project? $6.742.31 - $5,869.36 -57.699.25 $10,347.74 $5,176.83

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Please Answer in Excel and SHow all Steps X AFF 210 Problem Set TWO Winter 2022 PROBLEM ONE (20 MARKS) Sales Cost of Goods Sold Selling and Administrative Expenses Advertising Expenses Depreciation...

Please answer using excel and show formulas! Great ratings for good answers. Cash Flow Estimation and Risk Analysis Note: WACC (Weighted Average Cost of Capital) is the cost of capital (or discount...

Can you answer all of them? Because i don't know if they depend on the others ? Please solve in excel and show formulas.. If possible. Please upload excel on dropbox so i can download it. 1) What is...

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

please make an excel and show how you were able to do it. For sheet 1 after the grading criteria, how do i find COGS, the total wages is wrong, and the rest of the blank cells. For the startup costs,...

Question 1 Use the information provided to answer the questions. 1.1 1.2 Calculate the annual economic order quantity from the information provided below. INFORMATION GM Electronics expects to sell...

I did the first part of this, can I recieve help with the second part of it. I provided all the needed information to complete. I've had previously posted this and a chegg member helped me with 4...

I did the first half of this, can I recieve help with the second half of this? This is the beginning of the first part that was not provided. I'm providing it now. INPUT SECTION SALES 4th Quarter...

MUST SHOW FORMULAS IN EXCEL PLEASE AND THANK YOU CVP Modelling project The purpose of this project is to give you experience creating a multiproduct profitability analysis that can be used to...

1. Question 1: Answers to questions b) and c) Exhibit 1-A Exhibit 1-B 2. Question 2: Answers to questions a) through g) Exhibit 2-A Exhibit 2-B Exhibit 2-C 3. Question 3: Answers to all questions a)...

From a population of unknown mean and a standard Deviation = 5.0 a sample of n = 100 is selected and the sample mean 40.9 is found. Compare the concepts of estimation and hypothesis testing by...

Mast Industries and Bazak International were two textile firms. Mast orally offered to sell certain textiles to Bazak for $103,000. Mast promised to send documents confirming the agreement, but it...

How to calculate the total variable overhead variance?

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

8-17 Describe three spoofing tactics employed in identity theft using information systems.

8-9 A survey of your firms IT infastructure has identified a number of security vulnerabilities. Review the data on these vulnerabilities, which can be found in a table in MyMISLab. Use the table to...

8-11 This project will help develop your Internet skills in using the Web to research and evaluate security outsourcing services. You have been asked to help your companys management decide whether...