Q1. Below is the projected financial information provided by Altaf Hussain Manufacturing LLC. The company wants tointroduce two new products into the market, Zandu and Eundu. The company provides the following forecasted information ofsales and costs.Sales in unitsProduct/YearYear 1Year 2Year 3Year 4Zandu60,000110,000100,00030,000Eundu75,000137,000125,00037,500ProductZanduEunduDirect material costs1411Selling price3123Selling price inflation (per year).3%Direct material cost inflation (per year)3%Advertisement cost (First Year)500,000Advertisement cost (2nd and 3rd Year)200,000Investment1,000,000Machinery1,000,000Fixed costs1,000,000Таx25%Residual value1.2millionRequired:Calculate NPV and IRR of this proposal project using MS Excel.Hint:Calculate expected revenue2. Expected costs3. Expected cashflows1.to calculate NPV and IRRMTEES

Capital budgeting is the process of evaluating and selecting long-term investments that are in…

Answered: Calculate NPV and IRR of this proposal…

Business

Finance

Calculate NPV and IRR of this proposal project using MS Excel.

Entrepreneurial Finance

6th Edition

ISBN:9781337635653

Author:Leach

Publisher:Leach

Chapter4A: Nopat Breakeven: Revenues Needed To Cover Total Operating Costs

Section: Chapter Questions

Problem 1EP

See similar textbooks

Similar questions

Wallace Industries has total contribution margin of $58,560 and net income of $24,400 for the month of April. Wallace expects sales volume to increase by 5% in May. What are the degree of operating leverage and the expected percent change in income for Wallace Industries? 0.42 and 2.2% 0.42and5% 2.4andl2% 2.Sandl3%
A company is thinking of investing in one of two potential new products for sale. The projections are as follows: Year Revenue/cost £ (Product A) Revenue/cost £ (Product B)0 (150,000) outlay (150,000) outlay 1 24,000 12,0002 24,000 25,3333 44,000 52,0004 84,000 63,333 a) Calculate decimal. Please present answer to nearest half a month.
Ma2. Q4 Bundoora Enterprises operates a single-product entity. Data relating to the product for 2020 were as follows: Annual Volume 45,000 Units Selling price per unit $65 Variable manufacturing cost per unit $25 Annual fixed manufacturing costs $155,000 Variable marketing and distribution costs per unit $15 Annual fixed non-manufacturing costs $445,000 a) Calculate and interpret the break-even in units for 2020. b) Calculate and interpret the margin of safety in both units and sales dollars. c) Calculate and interpret the profit achieved in 2020.d) Changes in marketing strategy are planned for 2021. This would increase variable marketing and distribution costs by $15 per unit and reduce fixed non-manufacturing costs by $100,000 per year. Calculate and interpret the units that would need to be sold in 2021 to achieve the same profit as in 2020.
Rose Trading had RM210,000 of net profit in year 2021 when the selling price per unit was RM150, the variable costs per unit were RM90, and the fixed costs were RM570,000. Management expects per unit data and total fixed costs to remain the same in year 2022. The manager of Rose Trading is under pressure from investors to increase net profit by RM52,000 in year 2022.Required:(iii) Assume that Rose Trading sells the same number of units in year 2022 as it did in year 2021. What would the selling price have to be to reach the shareholders’ desired profit level?(iv) Assuming actual sales in year 2022 are 16,000 units with the new selling price as computed in (c), compute the margin of safety in (i) units and (ii) as a ratio. Briefly explain your findings. (Tips: Interpret about margin of safety)
INCOME STATEMENT Hermann Industries is forecasting the following income statement:Sales $8,000,000Operating costs excluding depr. & amort. 4,400,000EBITDA $3,600,000Depreciation & amortization 800,000EBIT $2,800,000Interest 600,000EBT $2,200,000Taxes (40%) 880,000Net income $1,320,000The CEO would like to see higher sales and a forecasted net income of $2,500,000. Assumethat operating costs (excluding depreciation and amortization) are 55% of sales and thatdepreciation and amortization and interest expenses will increase by 10%. The tax rate, whichis 40%, will remain the same. What level of sales would generate $2,500,000 in net income?
Two products DH1 and DH2are manufactured in a department. Sales for the year 2022 were planned as follows: Product Quarter 1 Quarter 2 Quarter 3 Quarter 4 DH1 9000 12000 14000 16000 DH2 7000 9000 1000 12000 Selling prices in Quarter 1 were estimated as OMR 20 per unit for DH1 and OMR 30 for DH2 respectively. Average sales return are 10% of Sales. According to these estimates, which of the following is estimated Sales (OMR) in Quarter 4 for Product DH1? Select one: a. 394129 b. 389253 c. 383328 d. 366000
The following selected data for BC Company for 2022: Sales P 2,000,000Variable Costs 1,200,000Traceable Fixed Costs 200,000Average Invested Capital 400,000Capital Charge 15% 1. The residual income amounted to? 2. Assuming the same information in the previous item, the return on investment percentage is?
1. DRS Sdn. Bhd. earned operating income last year as shown in the following income statement: Sales = 580000 Cost of goods sold = 333000 Gross margin = 247000 Selling and administrative expense = 190000 Operating income = 57000 At the beginning of the year, the value of operating assets was RM177,000. At the end of the year, the value of operating assets was RM277,000. DRS Sdn. Bhd. requires a minimum rate of return of 10%. a) Calculate the return on investment (ROI). b) Calculate the residual income (RI).
Q5. Beck Inc. and Bryant Inc. have the following operating data: Beck Inc. Bryant Inc. Sales $330,700 $1,056,000 Variable costs (132,700) (633,600) Contribution margin $198,000 $422,400 Fixed costs (132,000) (246,400) Operating income $66,000 $176,000 a. Compute the operating leverage for Beck Inc. and Bryant Inc. If required, round to one decimal place. Beck Inc. Bryant Inc. b. How much would operating income increase for each company if the sales of each increased by 20%? If required, round answers to nearest whole number. Dollars Percentage Beck Inc. $ % Bryant Inc. $ % c. The difference in the _________ of operating income is due to the difference in the operating leverages. Beck Inc.'s __________ operating leverage means that its fixed costs are a __________ percentage of contribution margin than are Bryant Inc.'s.
Consider the following information for a given business. Sale revenue =GHS40,000 VC per unit =GHS20 Activity level =1,000 to break even Required: 1. Determine the TFC 2. Express the contribution as a percentage of sale. 3. The company plans to sale 1,500 unit in the next period. What will be the percentage margin of safety (MoS) 4. What margin should the business employ for planning purposes? 5. What total profit should the business expect in order to achieve it's planned sales?
ABC Corp has the following data in year 2020: Sales 400,000; Variable cost 300,000 and Net loss 50,000. If the company wants to have a profit ratio of 10% of sales in year 2021, how much is the additional sale needed by ABC Corp to meet the target profit ratio?
Q2. A company wants to get its working capital calculated by you. You are given the following estimates for the year 2020. In addition to that add 10 percent to your figures for contingencies. Calculate the Net Working Capital for the year 2020.Assets and Liabilities Estimated Amount for 2020Miscellaneous Expenses (1 month )1200Stocks of finished goods 8000Stock of work in progress 7500 Rents -- 6 months 1800Stocks of raw materials 5000Average credit givenInland sales -- ( 3 weeks credits ) 5000Export Sales (1.5 weeks credit ) 2500Wages (1.5 weeks ) 1500Creditors (1.5 months )1000Salaries ( 0.5 month )4000Payment in advanceSundry Expenses 1000