Present Value and Future Value Formulas in Excel
Order ID 53563633773 Type Essay Writer Level Masters Style APA Sources/References 4 Perfect Number of Pages to Order 5-10 Pages Description/Paper Instructions
Present Value and Future Value Formulas in Excel
Index
Workbook Index Wk 3 – Set 1, Part 1 Wk 3 – Set 1, Part 2 Wk 3 – Set 2, Part 1 Wk 3 – Set 2, Part 2 Wk 3 – Set 2, Part 3 Wk 3 – Set 1, Part 1
Complete the following 7 Wk 3 Financial Exercises: Problem Set 1, Part 1 questions using either the financial functions in Excel® or the Present Value and Future Value formulas shown: Present value formula: PV = FV * 1 / (1+i)^n Future value formula: FV = PV * (1+i)^n Question Answer 1. If you want to have $60,000 in 8 years, how much do you need to deposit in the bank today if the account pays an interest rate of 9%? Insert your answer. 2. What will $110,000 grow to be in 9 years if it is invested today at 11%? Insert your answer. 3. You would like to have $200,000 in a college fund in 15 years. How much do you need today if you expect to earn 12% while you are investing to pay for your child’s college? Insert your answer. 4. 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? Insert your answer. 5. What will $82,000 grow to be in 11 years if it is invested today at 8% and the interest rate is compounded monthly? Insert your answer. 6. How many years will it take for $136,000 to grow to $468,000 if it is invested in an account with an annual interest rate of 8%? Insert your answer. 7. At what interest rate must $112,000 be invested so that it will be worth $392,000 in 14 years? Insert your answer.
Wk 3 – Set 1, Part 2
Complete the following 6 Wk 3 Financial Exercises: Problem Set 1, Part 2 problems: 1. Calculate the net present value (NPV) of the following cash flow stream if the required rate is 12%: Insert your NPV calculation. Year 0 1 2 3 4 5 Cash Flow (230,000) 60,000 60,000 60,000 60,000 60,000 Is this a good project for the business to accept? Explain why or why not. Insert your answer. 2. Calculate the NPV of the following cash flow projections based on a required rate of 10.5%: Insert your NPV calculation. Year 0 1 2 3 4 Cash Flow (120,000) 35,000 47,500 55,000 62,000 Is this a good project for the business to accept? Explain why or why not. Insert your answer. 3. A company needs to decide if it will move forward with 2 new products that it is evaluating. The 2 initiatives have the following cash flow projections: Project A Year 0 1 2 3 4 Cash Flow -800,000 220,000 265,000 292,000 317,000 Project B Year 0 1 2 3 4 5 Cash Flow -650,000 175,000 175,000 175,000 175,000 175,000 Based on the risk of each project, the company has a required rate of return of 11% for Project A and 11.5% for Project B. The company has a $1.5 million budget to spend on new projects for the year. Should the company move forward with one, both, or neither of the two new products? Show your work to support your answer. Insert your answer. 4. Calculate the internal rate of return (IRR) of the following cash flows: Year 0 1 2 3 4 5 6 7 Cash Flow (1,650,000) 330,000 365,000 380,000 415,000 405,000 370000 294,000 Insert your answer. 5. If a company has a required rate of return of 15%, should the following project be accepted based on these expected cash flows below? Year 0 1 2 3 4 5 6 Cash Flow (274,000) 68,000 73,000 76,500 78,000 82,500 77,000 Explain why or why not the company should move forward with this endeavor. Insert your answer. 6. Based on the investor expectations of earning at least 12%, should this projected below be completed? Year 0 1 2 3 4 5 6 Cash Flow (133,000) 37,000 42,750 44,000 46,500 82,500 77,000 Explain why or why not the company should move forward with this endeavor. Insert your answer. Describe the 5 types of budgets listed for these Wk 3 Financial Exercises: Problem Set 2, Part 1. In your descriptions, include the budget’s objective, how the budget assists an organization in managing its financial activities, and what types of data need to be included in that specific budget. Type of Budget Description Cash Flow Insert cash flow description. Operating Insert operating description. Sales Insert sales description. Static Insert static description. Financial Insert financial description. Wk 3 – Set 2, Part 2
Complete the following 3 Wk 3 Financial Exercises: Problem Set 2, Part 2 problems using the following ratios: Sales level at which operating income is zero o If sales above breakeven, then profit o If sales below breakeven, then loss o Fixed expenses = total contribution margin Total sales = total expenses Break Even Point: Unit Sold = Fixed expenses + Operating Income / Contribution Margin per unit Break Even Point: Sales $ = Fixed expenses + Operating Income / Contribution Margin Ratio Problem Answer 1. Calculate the break even number of units if the fixed expenses are $7,000 and the contribution margin is $14 per unit. Insert your answer. 2. Calculate the break even sales dollars if the fixed expenses are $7,000 and the contribution ratio is 40%. Insert your answer. 3. Calculate the break even number of units with a target profit of $120,000 if the fixed expenses are $15,000 and the contribution margin is $60 per unit. Insert your answer. Wk 3 – Set 2, Part 3
Complete the following 5 Wk 3 Financial Exercises: Problem Set 2, Part 3 problems: Problem Answer 1. How much will you have saved after 6 years by contributing $1,200 at the end of each year if you expect to earn 11% on the investment? Insert your answer. 2. A business owner plans to deposit their annual profits in an investment account earning a 9% annual return. If the owner starts with their first deposit today for $22,000 and expects to make the same profit for the next 7 years, how much will be saved for retirement at that point? Insert your answer. 3. An investor plans to invest $500 a year and expects to get a 10.5% return. If the investor makes these contributions at the end of the next 20 years, what is the present value of this investment today? Insert your answer. 4. What is the present value (PV) of a 12-year lease arrangement with an interest rate of 7.5% that requires annual payments of $4,250 per year with the first payment being due now? Insert your answer. 5. A recent college graduate hopes to have $200,000 saved in their retirement account 25 years from now by contributing $150 per month in a 401(k) plan. The goal is to earn 10% annually on the monthly contribution. Will they have the $200,000 at the end of the 25 years? Insert your answer.
RUBRIC
QUALITY OF RESPONSE NO RESPONSE POOR / UNSATISFACTORY SATISFACTORY GOOD EXCELLENT Content (worth a maximum of 50% of the total points) Zero points: Student failed to submit the final paper. 20 points out of 50: The essay illustrates poor understanding of the relevant material by failing to address or incorrectly addressing the relevant content; failing to identify or inaccurately explaining/defining key concepts/ideas; ignoring or incorrectly explaining key points/claims and the reasoning behind them; and/or incorrectly or inappropriately using terminology; and elements of the response are lacking. 30 points out of 50: The essay illustrates a rudimentary understanding of the relevant material by mentioning but not full explaining the relevant content; identifying some of the key concepts/ideas though failing to fully or accurately explain many of them; using terminology, though sometimes inaccurately or inappropriately; and/or incorporating some key claims/points but failing to explain the reasoning behind them or doing so inaccurately. Elements of the required response may also be lacking. 40 points out of 50: The essay illustrates solid understanding of the relevant material by correctly addressing most of the relevant content; identifying and explaining most of the key concepts/ideas; using correct terminology; explaining the reasoning behind most of the key points/claims; and/or where necessary or useful, substantiating some points with accurate examples. The answer is complete. 50 points: The essay illustrates exemplary understanding of the relevant material by thoroughly and correctly addressing the relevant content; identifying and explaining all of the key concepts/ideas; using correct terminology explaining the reasoning behind key points/claims and substantiating, as necessary/useful, points with several accurate and illuminating examples. No aspects of the required answer are missing. Use of Sources (worth a maximum of 20% of the total points). Zero points: Student failed to include citations and/or references. Or the student failed to submit a final paper. 5 out 20 points: Sources are seldom cited to support statements and/or format of citations are not recognizable as APA 6th Edition format. There are major errors in the formation of the references and citations. And/or there is a major reliance on highly questionable. The Student fails to provide an adequate synthesis of research collected for the paper. 10 out 20 points: References to scholarly sources are occasionally given; many statements seem unsubstantiated. Frequent errors in APA 6th Edition format, leaving the reader confused about the source of the information. There are significant errors of the formation in the references and citations. And/or there is a significant use of highly questionable sources. 15 out 20 points: Credible Scholarly sources are used effectively support claims and are, for the most part, clear and fairly represented. APA 6th Edition is used with only a few minor errors. There are minor errors in reference and/or citations. And/or there is some use of questionable sources. 20 points: Credible scholarly sources are used to give compelling evidence to support claims and are clearly and fairly represented. APA 6th Edition format is used accurately and consistently. The student uses above the maximum required references in the development of the assignment. Grammar (worth maximum of 20% of total points) Zero points: Student failed to submit the final paper. 5 points out of 20: The paper does not communicate ideas/points clearly due to inappropriate use of terminology and vague language; thoughts and sentences are disjointed or incomprehensible; organization lacking; and/or numerous grammatical, spelling/punctuation errors 10 points out 20: The paper is often unclear and difficult to follow due to some inappropriate terminology and/or vague language; ideas may be fragmented, wandering and/or repetitive; poor organization; and/or some grammatical, spelling, punctuation errors 15 points out of 20: The paper is mostly clear as a result of appropriate use of terminology and minimal vagueness; no tangents and no repetition; fairly good organization; almost perfect grammar, spelling, punctuation, and word usage. 20 points: The paper is clear, concise, and a pleasure to read as a result of appropriate and precise use of terminology; total coherence of thoughts and presentation and logical organization; and the essay is error free. Structure of the Paper (worth 10% of total points) Zero points: Student failed to submit the final paper. 3 points out of 10: Student needs to develop better formatting skills. The paper omits significant structural elements required for and APA 6th edition paper. Formatting of the paper has major flaws. The paper does not conform to APA 6th edition requirements whatsoever. 5 points out of 10: Appearance of final paper demonstrates the student’s limited ability to format the paper. There are significant errors in formatting and/or the total omission of major components of an APA 6th edition paper. They can include the omission of the cover page, abstract, and page numbers. Additionally the page has major formatting issues with spacing or paragraph formation. Font size might not conform to size requirements. The student also significantly writes too large or too short of and paper 7 points out of 10: Research paper presents an above-average use of formatting skills. The paper has slight errors within the paper. This can include small errors or omissions with the cover page, abstract, page number, and headers. There could be also slight formatting issues with the document spacing or the font Additionally the paper might slightly exceed or undershoot the specific number of required written pages for the assignment. 10 points: Student provides a high-caliber, formatted paper. This includes an APA 6th edition cover page, abstract, page number, headers and is double spaced in 12’ Times Roman Font. Additionally, the paper conforms to the specific number of required written pages and neither goes over or under the specified length of the paper. GET THIS PROJECT NOW BY CLICKING ON THIS LINK TO PLACE THE ORDER
CLICK ON THE LINK HERE: https://www.perfectacademic.com/orders/ordernow
Also, you can place the order at www.collegepaper.us/orders/ordernow / www.phdwriters.us/orders/ordernow
Do You Have Any Other Essay/Assignment/Class Project/Homework Related to this? Click Here Now [CLICK ME]and Have It Done by Our PhD Qualified Writers!!