Question

In: Economics

Bonus Question: Use the provided excel file to solve this question). A small company receives an...

Bonus Question: Use the provided excel file to solve this question). A small company receives an annual order of 800 units which are sold at $85 per unit. The production cost is $30 per unit and the fixed cost per year is $3,500. The initial investment is $ 75,000 and can be depreciated on a MACRS basis over a seven-year period where the marginal income tax rate is 35%. At the end of 4 years, the company is expected to retain a market value of 30% of the initial investment. Determine the required annual sales units to break even, given that MARR is 15%. (Choose the closest answer):

a) 565 units

b) 622 units

c) 590 units

d) 543 units

None of the above choices is correct

Solutions

Expert Solution

Rahul Sunny answered 1 year ago
Next > < Previous

Related Solutions

Please use excel file to solve You are evaluating a project for your company. The project...
Please use excel file to solve You are evaluating a project for your company. The project will require equipment that has a purchase price of $500,000, and will need to include $60,000 for delivery costs and $70,000 for installation related expenses. The equipment will be depreciated using MACRS as a 10 year class asset. Assume you expect a salvage value of $50,000 at the end of the projects life. In addition, land will need to be purchased for $1,500,000. The...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided...
Instructions: You are required to use a financial calculator or spreadsheet (Excel) to solve the provided capital budgeting problem (sample questions and solutions are provided for guidance). Problem: Windrunner Corp. is considering a new machine that requires an initial investment of $800,000 installed and has a useful life of 10 years. The expected annual after-tax cash flows for the machine are $120,000 during the first 5 years, $150,000 during years 6 through 8 and $180,000 during the last two years....
1. Use Microsoft Excel to solve the question . The initial cost of an asset is...
1. Use Microsoft Excel to solve the question . The initial cost of an asset is BD100000. It has useful life of 9 years. The estimated salvage value of the asset at the end of useful life is zero. Calculate the annual depreciation and book value using double-declining balance method and find out the year in which the switching is done from double-declining balance method to straight-line method. Theory related to switching : Switching between different depreciation methods:- Switching from...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company...
Please use Excel to solve the assignment and submit as an excel spreadsheet. Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the...
Use Excel Analysis ToolPak to solve. Recent family home sales in San Antonio provided the following...
Use Excel Analysis ToolPak to solve. Recent family home sales in San Antonio provided the following data (San Antonio Realty Watch website, November 2008). Square Footage   Price ($) 1580   142,500 1572   145,000 1352   115,000 2224   155,900 1556   95,000 1435   128,000 1438   100,000 1089   55,000 1941   142,000 1698   115,000 1539   115,000 1364   105,000 1979   155,000 2183   132,000 2096   140,000 1400   85,000 2372   145,000 1752   155,000 1386   80,000 1163   100,000 a. Develop the estimated regression equation that can be used to predict...
An executive in a merchandising company receives an annual bonus equal to 5% of net income....
An executive in a merchandising company receives an annual bonus equal to 5% of net income. Historically, the company has calculated cost of goods sold and ending inventory using LIFO and has maintained 30,000 of units in inventory for the last ten years. The executive is recommending the company reduce the number of units in year-end inventory to 1,000. Over the ten-year period, the cost per unit of inventory has increased from $60 per unit to $110 per unit. Respond...
An executive in a merchandising company receives an annual bonus equal to 5% of net income....
An executive in a merchandising company receives an annual bonus equal to 5% of net income. Historically, the company has calculated cost of goods sold and ending inventory using LIFO and has maintained 30,000 of units in inventory for the last ten years. The executive is recommending the company reduce the number of units in year-end inventory to 1,000. Over the ten-year period, the cost per unit of inventory has increased from $60 per unit to $110 per unit. Respond...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You...
Please do it in MS Excel Required: Solve these question in Microsoft Excel Question 01: You want to retire on the day you have $1,000,000 is your savings account. You expect to earn 4 percent compounded monthly, on your money during your retirement. Your plan is to withdraw $4500 a month as retirement income from this account. How many years can you be retired until you run out of money? . Question 02: you are able to pay mortgage payments...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to...
I need this in an excel file with formulas please: 1) Use an Excel spreadsheet to solve problem #31 (the PUTZ, Inc. project) for Chapter 10 in the textbook. 2) Conduct a sensitivity analysis that focuses on the sales price by increasing the price by 10% above the best estimate, and then by decreasing the price by 10% below the best estimate. 3) You must provide one spreadsheet for each of the three situations—the base case estimate, the best case,...
Using the data provided in the excel file, show all of your work for the following...
Using the data provided in the excel file, show all of your work for the following calculations: a.) mean temperature of unmixed reagents (oC) b.) δελταT from graph (oC) c.) q absorbed by reaction mixture (J) d.) q absorbed by calorimeter, stirrer, and thermometer (J) e.) q total absorbed (J) f.) q total released (J) g.) calculation to show limiting reagent h.) deltaH neutralization for the reaction (kJ/mole of acid) A student reacted 100.0 mL of 0.9800 M HCl with...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT