Reference no: EM131119421
Problem: Suppose you have a capital budgeting proposal that includes a machine that will cost $420,000 and the project will last 7 years. The machine will be mounted on a truck you currently own. This truck was purchased for $100,000, has a book value of $10,000 and could be sold for $50,000 (net of taxes) should you choose not to accept the capital budgeting proposal. The new machine is expected to be sold at the end of the project for $50,000 (gross of taxes), but will be depreciated completely (use straight-line depreciation). You have spent $100,000 in market research related to this new product. You expect that the project will result in $125,000 in annual revenues and $54,000 in annual expenses (for what it's worth, $9,000 of the $54,000 in expenses is 1/6th allocation of the salary and fringe benefits of a well-paid security guard that currently oversees the manufacturing building). A $30,000 recoverable investment in working capital will be required to get the project started and will remain at that level throughout the life of the project. The applicable marginal tax rate is 30% and the cost of capital is 6%.
Question 1: Find the NPV of this project. (Note: You might wish to use the Excel NPV function, just realize the Excel NPV function assumes the first cash flow in your range is one year in the future. Thus, you need a "two-part" function. I strongly suggest you calculate it "by hand" to double check your answer. Whether you use the NPV function or not, you must use formulas in Excel to calculate your NPV. Trust me -- I will check EVERY SINGLE assignment.)
Question 2: Does your answer change if the annual revenues grow at an annual rate of 5% each year beyond the first year? Repeat question 1 with this new assumption. You must also use formulas to adjust your cash flows!
Question 3: Now, go back to the original question. Assuming all of the other projections do not change, approximately how much revenue (assume it is the same each year) is needed to get a NPV = 0. (An NPV within five dollars plus/minus zero is sufficient. Note, Trial and Error is OK, but the Solver Function under the Data tab works really slick if you can figure it out! HINT: It won't work unless you use formulas throughout your spreadsheet. Also, if you can't find Solver, you might have to add it via "File-Options" within Excel.)
Bonus - For the original problem, please use the Excel spreadsheet function to determine the IRR of the project. For credit, this must be displayed on the page for Question 1 and must use the Excel spreadsheet function.
Identify country that you are comparing with united states
: Write a 1- to 2-page paper in which you: Identify the country that you are comparing with the United States. Define the three health indicators you have selected for your analysis and explain why you chose them
|
How many boxes of lettuce should the supermarket purchase
: The local supermarket buys lettuce each day to ensure really fresh produce. Each morning any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. How many boxes of lettuce should ..
|
Discuss whether culture is more individualistic
: Discuss whether the culture is more individualistic or collectivistic. Provide relevant examples highlighting key concepts. Reflect on the role of cultural relativism in your overall impression of the culture.
|
Solid waste management company
: You are the project manager for Heaping Hills, a solid waste management company, who wants to bring a new landfill operation to the town of Williamsville. As the project manager, your task is to create a presentation for the community at the town ..
|
Find the npv of this project
: Bonus - For the original problem, please use the Excel spreadsheet function to determine the IRR of the project. For credit, this must be displayed on the page for Question 1 and must use the Excel spreadsheet function.
|
Think of a charismatic
: Think of a charismatic [Someone possessing the ability to attract others by their personality and actions] person you have encountered. What character traits did he or she exhibit?
|
In light of whole foods distinctive management philosophy
: Whole Foods Market is, in many aspects, an unusual corporation. As the base case illustrates, John Markey and his partners are not typical corporate leaders. In light of Whole Foods’ distinctive management philosophy, structure and values (e.g. soci..
|
Define determinism - fatalism and free will
: Distinguish between natural (scientific) determinism and theological (religious) determinism. Discuss whether or not you believe free will and determinism can be compatible.
|
Discuss the program and what led to its implementation
: Briefly discuss the program and what led to its implementation. In general, what are the different types of program evaluation available to a manager
|