need excel homework done

General Directions:In this assignment, you’ll be using Excel to do a capital budgeting analysis and a couple of time value of money exercises and a bit of financial statement analysis.You can do this assignment in groups of up to three.The choice of group members (or doing it by yourself) is yours.You can work with people in sections other than yours if you wish.In doing this assignment, I ask that you hand in the solutions (with row and column headings printed) and print out the formulas that generated the solutions (also with row and column headings printed).This will include some financial functions which you may (or may not) recall from Digital Strategies, for those of you in CSOM.

Capital Budgeting

You’re considering a project that will last for 8 years.You have to invest $600 million in fixed assets, plus an additional $8 million in net working capital initially.The fixed assets will be depreciated as a 10 year asset using MACRS rules.A copy of the MACRS tables may be found on the reverse side of this page.Sales in the first year are expected to be $160 million, with operating expenses excluding depreciation expected to be $70 million.During the project, you expect that you can increase sales by 4% per year, while operating expenses will rise by 3% per year.Net working capital will be 5% of sales.The NWC increase to support year 1 sales is addressed in the initial investment.NWC is needed one year in advance (NWC needed to support year 2 sales must be funded in year 1, for example).At the end of the project, you can sell the equipment for $70,000,000.Let your firm’s cost of capital be 7% and the firm’s tax rate be 20%.Find the NPV, the IRR and the MIRR of the project.Do you accept or reject the project?Please note that this will be much easier to do if you give a bit of thought as to how to address the growth rates in setting up the spreadsheet.

The Time Value of Money (do with your own formulas, not tables)

  • Suppose you want to live in a home in Tucson, AZ upon retirement.You plan to set aside $25,000 one year from now and you plan to increase that annual contribution by 4% per year.You earn 7% on your investments.You have $125,000 saved.You want to retire in 40 years.In today’s dollars, how much will you have put toward your estate if the last payment is on the day you retire?How much will this be on the day you retire and actually buy the estate?
  • You are following Ehrlich’s Excellent Edifices (3E – a very successful construction firm) stock.You’re asked to value the firm’s stock.You’re told the firm will pay a dividend of $2 next quarter.You estimate the firm’s dividends will grow at 3% per quarter for 3 years; then at 2% quarterly for 6 years; then at 1% quarterly thereafter.The discount rate is 9% per year, compounded annually.Find the stock price.
  • You plan to be a doting parent for your three adorable tots (you love to plan ahead).You plan to set up a fund to pay for their law school educations immediately after their undergraduate studies.The fund will be set up to pay each little one $175,000 for the first year of school, then increase at 4% per year through graduation.Assume the kids graduate after 3 years of law school.The oldest tot begins law school in 18 years; the second one starts two years later and the last little one starts one year after the second.You have set aside $75,000 thus far.You earn 8% on your investments.Next year’s salary is expected to be $220,000.What fraction of your salary must you set aside if you get raises of 2% per year to make your vision a reality?You start your savings based on income one year from now and you make your last payment on the first child’s first day at law school.
#write essay #research paper #blog writing #article writing #academic writer #reflective paper #essay pro #types of essays #write my essay #reflective essay #paper writer #essay writing service #essay writer free #essay helper #write my paper #assignment writer #write my essay for me #write an essay for me #uk essay #thesis writer #dissertation writing services #writing a research paper #academic essay #dissertation help #easy essay #do my essay #paper writing service #buy essay #essay writing help #essay service #dissertation writing #online essay writer #write my paper for me #types of essay writing #essay writing website #write my essay for free #reflective report #type my essay #thesis writing services #write paper for me #research paper writing service #essay paper #professional essay writers #write my essay online #essay help online #write my research paper #dissertation writing help #websites that write papers for you for free #write my essay for me cheap #pay someone to write my paper #pay someone to write my research paper #Essaywriting #Academicwriting #Assignmenthelp #Nursingassignment #Nursinghomework #Psychologyassignment #Physicsassignment #Philosophyassignment #Religionassignment #History #Writing #writingtips #Students #universityassignment #onlinewriting #savvyessaywriters #onlineprowriters #assignmentcollection #excelsiorwriters #writinghub #study #exclusivewritings #myassignmentgeek #expertwriters #art #transcription #grammer #college #highschool #StudentsHelpingStudents #studentshirt #StudentShoe #StudentShoes #studentshoponline #studentshopping #studentshouse #StudentShoutout #studentshowcase2017 #StudentsHub #studentsieuczy #StudentsIn #studentsinberlin #studentsinbusiness #StudentsInDubai #studentsininternational