Your friend has asked you to help him with a capital needs analysis. You calculated that total cash available will be $540,000, your friend’s estate’s obligation will be $130,400, net monthly income required for your friend’s survivor is estimated to be $1,900 per month. Using a 5% discount rate, what would be the amount of total additional capital needed?

You work for an outdoor play structure manufacturing company and are trying to decide between the following two projects: (Click on the following icon in order to copy its contents into a spreadsheet.) Project Playhouse Fort Year-End Cash Flows ($ thousands) 1 2 18 IRR 33.8% 13.2% 52 You can undertake only one project. If your cost of capital is 7%, use the incremental IRR rule to make the correct decision. 0 -25 -75 The incremental IRR is%. (Round to two decimal places.) 20 39 Save OL

The Jeffersons have asked you what would be needed to fund the children’s future college costs. Assume each child will begin college at age 18 and graduate in four years. Assume current costs are $24,000 per year and are expected to increase by 5% per year and investments earn 7%.   A.      Assuming no existing assets are dedicated to college, what is the annual savings amount required to fund the children’s education? The Jeffersons’ goal is to have an amount at the beginning of the freshman year for each child that is sufficient to fund a serial payment covering the $24,000 of current costs of college adjusted for inflation for each of the four years of college. Please include your calculator keystroke inputs [PV, I/YR, N, FV, and PMT (if needed)] for each step of this calculation. Also include whether any PMTs are in the end mode or the begin mode. B.      What would you say to the Jeffersons about their education funding situation? Write a script of a single paragraph as if you…

How do I work this problem in excel? You have been offered $3,000 in 4 years for providing $2,000 today into a business venture with a friend. If interest rates are 10%, is this a good investment for you?