12 Jul DETAILS ON THE ANNUAL UNIT SALES ARE GIVEN IN THE SPREADSHEET TEMPLATE, HIGHLIGHTED IN YELLOW. ?
The instructions on how to do it is on pdf file. the template is on excel. Document Preview: Capital Budgeting Case: Part I I. Instructions: This case is designed to be an excel spreadsheet case. Please show your work by using formulas and cell references in excel. Use the excel spreadsheet template that is available on Blackboard, under Assignments, for more details. Please show your work for the sensitivity analysis in question #2 in a separate sheet in excel. You may round to two decimal places in your calculations. Suppose Sunshine Outfitters, Inc., is considering the following project, where all of the dollar figures are in thousands of dollars. ? In year 0, the project requires an $11,500 investment in plant and equipment. This equipment is depreciated using the straight-line method over seven years, and has a salvage value (after-tax) of $1,200 in year 7. ? The project is expected to generate sales of 3,000 units in year 1. Details on the annual unit sales are given in the spreadsheet template, highlighted in yellow. ? Sales revenue per unit is forecast to be $10.00 in year 1 and then grow with inflation. ? Variable cost per unit is forecast to be $7.50 in year 1 and then grow with inflation. ? Cash fixed costs are forecast to be $5,280 in year 1 and then grow with inflation. ? The inflation rates that apply each year (to sales, VC, and FC) are shown in the spreadsheet. ? The company uses a 13.2% discount rate to evaluate new product decisions. ? The tax rate is forecast to be a constant 35.0%. ? The project will require working capital in the amount of $0.90 in year 0 for every unit of next year’s forecasted sales, and this amount ($0.90) will grow with inflation going forward. 1) What is the project’s NPV? What is the IRR? Would you accept this project? 2) Suppose you need to do some sensitivity analysis (please show on separate worksheet): (a) What if the firm suspects that this project is riskier than the firm’s average project and decides to increase the cost of capital to 15%. What is the NPV? (b) What if the firm fears that its variable costs… Attachments: Capital-Budge….pdfcapital-budge….xlsx
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.