Fine Metal Flexible Budget & Perfomance Evalauation Excel
PART II You need to create an excel spreadsheet that answers the following questions. Where stated, make sure you solve the problem “by hand”, i.e. discounting each cash flow, and also using TVM formulas from Excel. All work should be presented in three sheets/tabs (not files). Your sheets should be labeled. Questions 1-4 are in the first tab, questions 56 are in the second tab, and question 7 is in a third tab. In all cases, presentation matters!!! Make these professional. Also, all work should be set up in such a way that you could change one parameter and have the formula automatically update, i.e. you need an assumptions section. In other words, you would want to be able to do a basic type of “what-if” analysis. Hard-coding values is bad, formulas are good. 1. Find the FV of $10,000 33 years in the future if the opportunity cost rate is 8% (use Excel formulas and basic PV/FV techniques). 2. Find the PV of $1,000,000 to be delivered in 16 years if the opportunity cost rate is 7% (use Excel formulas and basic PV/FV techniques). 3. Would you prefer the following (you can use just formulas for this problem): 1. An ordinary annuity where you receive $500 each year for 20 years if the opportunity cost is 6% 2. An annuity due where you receive $480 each year for 20 years if the opportunity cost rate is 5.9% 4. What is the net present value of the following stream of cash flows assuming the opportunity cost rate is 12%? Solve NPV using each cash flow and the NPV function in Excel (use Excel formulas and basic PV/FV techniques). Year 0: -$10,000 Year 1: $4,000 Year 2: -$2,000 Year 3: $5,000 Year 4: $3,000 Year 5: $6,000
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
