1. You will decide on a new project with a 5-year life and following data;
• You expect sales as $10,000 in the first year of operation but the sales in subsequent years are uncertain. Estimated sales growth is assumed to be normally distributed with a mean of 3% and a standard deviation of 2%. Costs of goods Sold (COGS) each year are uncertain as well but are assumed to be a percentage of sales. COGS as a percentage of sales is assumed to be distributed normally with a mean of 40% and a standard deviation of 6%.
• Fixed costs will be $3,300 per year.
• The project will require an initial investment in net working capital of $400. Beginning at year 1, NWC is 10% of sales. The entire NWC investment (across all years) will be recovered at the end of the project.
• To operate the project, a new piece of equipment must be purchased at a cost of $10,000. The equipment will be depreciated using straight line depreciation.
• The equipment will have 0 salvage value by the end of the project.
• The cost of capital facing the firm is 10%.
• Tax rate is 25% Mean Std Dev Sales Growth 3% 2% COGS/Sales 40% 6% Fixed Cost $3,300 NWC as % of Sales 10% Tax Rate 25% Cost of Capital 10%
Tasks: a) Calculate the NPV of the project while capturing the uncertainty in sales and costs of goods sold.
b) Simulate the NPV 1000 times using a data table.
c) Calculate mean, standard deviation, min and max values for projected NPVs
d) Calculate the probability of positive NPV
Can you include formulas in excel? I don’t know what more information you would need because this is all the info we are given. Get Finance homework help today
We aim at 100% customer satisfaction. As such, we never compromise on the quality of our assignment services. Our homework helpers craft each paper carefully to match the requirements on the instruction form.
We receive many applications from writers around the world daily. Nevertheless, we only choose the cream of the crop to tackle your “help with homework” requests. Hence, our homework helpers are highly-qualified individuals who maintain our quality policy.
We maintain a fair pricing policy for all our homework help services. Our pricing system generates quotations based on the requirements of each paper.
At My Homework Writers, we guarantee all students swift delivery of their assignments. We understand that time is an essential factor in the academic world. We, therefore, ensure that all assignments are delivered on or before the agreed deadline.
We maintain a zero-plagiarism policy in all our essay papers. Our assignment writers stick to the students’ instructions to deliver plagiarism-free papers. We are also keen to avoid any chance of similarities with previously written papers.
We understand that you might run into trouble once in a while when working with our system. In the event that you do run into trouble, please get in touch with our support agents and they will immediately provide you with assistance.
Feel free to contact us via the Chat window or email: firstname.lastname@example.org.
Follow these simple steps to get your homework done
Fill in the order form and provide all details of your assignment.
Choose the payment system that suits you most.
You will be able to track the progress of your paper from our system.
Once your paper is ready, we will email it to you.
Myhomeworkwriters website holds a reputation for providing high-quality assignment writing services. You only need to give us all the requirements for your “do my homework” order, and our homework paper writers will give you the best results.
We have highly qualified essay writers to assist you whenever you place in "help with my homework" order. Our essay writing service is designed to help students get good grades.
Our admission essay writing help will assist you to secure a position at your desired learning institution. We will help you craft a top-notch personal statement paper. Our writers who know how to write a college admission essay will help you get the college admission you are longing for.
Our team of professional editors will help you organize your paper, paraphrase it, and eliminate any possible mistakes. Also, we will help you check on plagiarism to ensure that your final paper possesses quality and originality.
My homeworkwriters harbors specialists who can handle your technical papers order. Our “write my homework” services cover all academic areas you can think of. The simplicity or complexity of the paper does not affect the quality of assignment writing services.