Assignment Coursera Essay Example for Free

Assignment Coursera EssayScore Explanation 6. 34 Correct 5. 00 Correct. This is where a spreadsheet comes in handy. congeries 5. 00 / 5. 00 school principal Explanation This is a simple IRR calculation. Drawing a time problem helps. Question 3 (5 points) Austin needs to purchase a raw heating/cooling musical arrangement for his home. He is thinking close to having a geothermal formation installed, but he wants to know how tenacious it bequeath take to recoup the additional damage of the system. The geothermal system pass on cost $20,000. A conventional system testament cost $7,000. Austin is eligible for a 30% tax ascribe to be applied immediately to the purchase. He estimates that he will save 1 ,500 per class in utility bills with the geothermal system. These cash kayoedflows can be aimd to occur at the end of the year. The cost of capital (or interest put) for Austin is 7%. How long will Austin have to use the system to entirelyify the additional expense over the conventional model? ( i. e, What is the DISCOUNTED payback period in old age? Discount future cash flows before calculating payback and round to a whole year. ) practice for Question 3 Your wait on Score 6 Correct. You dismissed before calculating payback, but it still is a very myopic measure.Total Simple payback calculation, but with discounting. Question 4 (10 points) In postgraduate school Jeff often made money in the summer by mowing lawns in the neighborhood. He Just finished his freshman year of college and, after taking a Business 101 class, he has nigh ideas about how to scale up his lawn mowing operation. Previously, he had used his fathers push lawn mower, but he is thinking about getting a r101ng mower tnat wlll save tlme ana allow nvm to 00 more lawns. He Touna a used, zero turn, riding mower on Craigslist for $1,200.He will also need a radio-controlled aircraft to pull the mower behind his pickup that will cost him an additional $600. With the new ower he can take on an additional 20 lawns per week at an average cash inflow of $20 per lawn he will receive at the end of each week. He has 14 weeks of summer in which to mow lawns. (For convenience, assume that the mower and trailer will have no value after Jeff is done with his work this summer. ) The discount rate for Jeff is 10% (Keep in mind this is an annual rate). What is the Net Present Value of the mower/trailer project? Your Answer -1147 3117 4320 3720 10. 00 Correct.You know how to set up and calculate wv, at a weekly interval. Total 10. 00 / 10. 00 A fairly common NPV problem, with weekly compounding. Question 5 (10 points) Yassein is looking to refinance his home because rate have gone eat up from when he bought his house 10 years ago. He started with a 30-year fixed-rate owe of $288,000 at an annual rate of 6. 5%. He can now get a 20-year fixed-rate mortgage at an annual rate of 5. 5% on the remaining balance of his initial mortgage. (All loans require periodic payments. ) In order to re-flnance, Yassein will need to pay closing costs of $3,500.These costs are out of pocket and cannot be rolled into the new mortgage. How much will re backing save Yassein? (i. e. What is the NPV of the refinancing decision? Your Answer 16467 17517 16975 Correct. This is a very common situation we all face all the time. 15463 A problem we saw destruction week, but I expect you to do this routinely now. It is a value generating opportunity through financing only because interest rates changed. Question 6 (10 points) Chandra has the opportunity to buy a vacant serve next to several commercial properties for $50,000.She plans to buy the property and spend another $60,000 immediately to put in a parking lot. She has talked to the local businesses and has some contracts lined up to fill the parking spaces. The profits from the ontracts will provide $25,000 per year and the contracts will last 10 years. What is the NPV of Chandras plan if the appropriate discount/interes t rate is 10%? (Enter Just the number without the $ sign or a comma round off decimals. ) Answer for Question 43614 Correct. You know how to calculate NPV. Questlon Explanatlon A standard NPV problem.Question 7 (10 points) This question introduces you to the concept of an rente with growth. The mandate is given on p. 3, equation (7), of the Note on Formulae, but I would encourage you to try doing it in Excel as well. (If the first cash flow is C, the next one ill be C(l+g), and so on, where g is the growth rate in cash flow). As an example, the present value of an annuity that starts one year from now at $100, and grows at 5%, with the last cash flow in year 10, when the discount rate is 7%, is $860. Confirm this before attempting the problem using both the formula and excel.What is the NPV of of a new manufacturing project that costs $100,000 today, but has a cash flow of $15,000 in year 1 that grows at 4% per year till year 12? Similar investments earn 7. 5% per year. (Enter Ju st the number without the $ sign or a comma round off decimals. ) Answer for Question 7 0486 Correct. Hope you used both methods. This is a set up and calculation problem, nothing new conceptually. Question 8 (1 5 points) Diane has Just 18 and also completed high school and is question about the value of a college education.She is pretty good with numbers, and driven by financial considerations only, so she sits down to calculate whether it is worth the large sum of money. She knows that her first year tuition will be $12,000, ascribable at the beginning of the year (that is, right away). Based on historical trends she estimates that tuition will ski tow at 6% per year for the 4 years she is in school. She also estimates that her living expense in a higher place and beyond tuition will be $8,000 per year (assume this occurs at the end of the year) for the first year and will increase $500 each year thereafter to keep up with inflation.