Question

In: Finance

Instructions: After you have completed the calculations on your spreadsheet that correlates to the questions below,...

Instructions: After you have completed the calculations on your spreadsheet that correlates to the questions below, you will copy and paste the portion of that spreadsheet into the Word document for each of the questions. Be sure to also provide a sentence that explains the solution.

To save for her newborn son ’s college education, Lea Wilson will invest $1,000 at the end of each year for the next 20 years. The interest rate is 10%. What is the future value? Answer: Excel sheet - copy and paste into this document

Sharon Smith will receive $1 million in 20 years. The discount rate is 10%. As an alternative, she can receive $200,000 today. Which should she choose? $200,000 Answer: Excel sheet - copy and paste into this document Dr. J. wants to buy a Dell computer that will cost $3,000 three years from today. He would like to set aside an equal amount at the end of each year in order to accumulate the amount needed. He can earn an 8% annual return. How much should he set aside at the end of each year? Answer: Excel sheet - copy and paste into this document

You will deposit $200,000 today. It will grow for five years at 12% interest, but compounded semi-annually. What will your investment grow to? Answer: Excel sheet - copy and paste into this document

John Doeber borrowed $150,000 to buy a house. His loan cost was 6% and he promised to repay the loan in 10 equal annual payments. What are John’s annual payment amounts? Answer: Excel sheet - copy and paste into this document

An organization would like to expand a large piece of equipment in their factory that would help make the process more efficient in the future. If they are able to invest $400,000 for an initial payment, determine the approximate future value to begin installation at the beginning of the third year. We can assume an interest rate of 7% annually. Answer: Excel sheet - copy and paste into this document

After 10 years, some shares of stock originally purchased for $500 total were sold for $900 total. What was the yield on the investment? Hint PV is input as a negative value Answer: Excel sheet - copy and paste into this document

Kathy has $50,000 to invest today and would like to determine whether it is realistic for her to achieve her goal of buying a home for $150,000 in 10 years with this investment. What return must she achieve in order to buy her home in 10 years? Hint PV is input as a negative value Answer: Excel sheet - copy and paste into this document

Expert Solution

1]

Future value is calculated using FV function in Excel :

rate = 10% (interest rate)

nper = 20 (number of years)

pmt = -1000 (Yearly investment. This is entered with a negative sign because it is a cash outflow)

FV is calculated to be $57,275.00

2]

Sharon Smith should choose the option with the higher present value.

Present value of receiving $1 million in 20 years is calculated using PV function in Excel :

rate = 10% (interest rate)

nper = 20 (number of years)

pmt = 0 (yearly payment is zero)

fv = -1000000 (Amount received after 20 years. This is entered with a negative sign because we are calculating PV of an amount received in the future)

PV is calculated to be $148,643.63

Sharon Smith should choose to receive $200,000 today because it is higher than the present value of receiving $1 million in 20 years.

3]

We calculate the yearly saving required to accumulate the required amount in 3 years using PMT function in Excel :

rate = 8% (rate of return earned)

nper = 3 (number of years)

pv = 0 (amount currently saved is zero)

fv = 3000 (required amount in 3 years)

PMT is calculated to be $924.10

4]

Future value is calculated using FV function in Excel :

rate = 12% / 2 (convering annual interest rate into semiannual rate)

nper = 5 * 2 (total number of semiannual periods = number of years * 2)

pmt = 0 (Yearly investment is zero)

pv = -200000 (amount invested today)

FV is calculated to be $358,169.54

jeff jeffy answered 2 years ago

Since each question correlates to the other question please supply all ten questions in a spreadsheet...

Since each question correlates to the other question please supply all ten questions in a spreadsheet style format : Brad's Baskets, a manufacturing business that sells baskets, wants a master budget prepared for the first three months of this year (January, February and March). The managers of the different departments have provided the following information: The Sales Manager has projected the following sales: January 5,000 units February 4,000 units March 6,000 units April 5,000 units May 11,250 units Projected selling...

Instructions: Using the data for the assignment complete your spreadsheet and answer the five questions. When...

Instructions: Using the data for the assignment complete your spreadsheet and answer the five questions. When you make the changes for question 4 and 5 your spreadsheet will change and your spreadsheet answer from the previous question may change depending on how you build your spreadsheet. That is OK, we can look at your spreadsheet and do some quick checks. Again, we are expecting to see formulas/functions in the spreadsheet. This assignment is similar to the Biz Café Individual Assignment...

n the instructions for this Task C, we're going to assume that you have completed your...

n the instructions for this Task C, we're going to assume that you have completed your script for Task B above; i.e. that you have a working dictionary-based version of the functions (originally named addToRecord(), etc. in Task A) now named addToHistogram(), etc. Let's assume that your dictionary-based function (from Task B above) that creates a histogram is named makeHistogram(). You are going to use your makeHistogram() in the following sub-tasks. In fact, you're welcome to include any function you...

Calculations must be done in Excel – You must create your own spreadsheet do not copy...

Calculations must be done in Excel – You must create your own spreadsheet do not copy and paste someone else’s. Polycorp Limited Steel Division is considering a proposal to purchase a new machine to manufacture a new product for a potential three year contract. The new machine will cost $1.9 million. The machine has an estimated life of three years for accounting and taxation purposes. Installation will cost a further $120,000. The contract will not continue beyond three years and...

Instructions 1. Provide an original post with your answers to the questions below and reply to...

Instructions 1. Provide an original post with your answers to the questions below and reply to at least two classmates. Do not upload a document. 2. Do not repeat the questions in your post, but do number your answers. 3. A complete answer post is several sentences in length, and will: (1) define and explain the correct legal terms, rules, and principles, (2) apply the legal rules and principles to the facts in the question, (3) state a conclusion, and...

Instructions: The below list of open-ended questions are meant to guide your study. Your goal is...

Instructions: The below list of open-ended questions are meant to guide your study. Your goal is to: explain the answer to each question verbally and use graphical or algebraic examples in your explanation. This is a micro econ question. 47. Explain the three theories of profit and give examples of each.

Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do...

Project 2 Calculations must be done in Excel – You must create your own spreadsheet (do not copy and paste someone else’s). This question should be done using Method 1 as outlined in lecture 6 (i.e. Tax Effects, then Cash Flows then NPV) As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have...

the following questions refer to homeostasis. a) you have just completed your first ironman (a very,...

the following questions refer to homeostasis. a) you have just completed your first ironman (a very, VERY strenuous event). you are very hot since this is a very intense race. DESCRIBE ALL THE CHANGES that would occur in your body to restore homeostasis. is this a negative or positive feedback loop? explain. no diagrams please explain thoroughly. b) describe thoroughly how exactly the endocrine system works and helps to keep the body at homeostasis. no diagrams please explain thoroughly.

Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each...

Complete the questions below. Submit only an Excel spreadsheet with your name, one tab for each question, and your Excel Solver solution; ensure that you clearly identify each answer. A local pastry shop is planning their next morning’s production. The shop has three main items that they sell: cakes, cupcakes, and cannolis. All of these are made in-house with the shop’s own ingredients. The recipes for these items are as follows: Cakes: 5 eggs, 2 cups flower, 15 g of...

After you have completed your readings, go back to Exercise 8.8 and read the RadioShack case...

After you have completed your readings, go back to Exercise 8.8 and read the RadioShack case study (located in footnotes). After reading the RadioShack article, answer the following questions with complete, descriptive responses: DISCUSSION QUESTIONS What is the rationale for conducting mass layoffs through electronic communication or other, impersonal methods? Do you see any advantages? Do you feel that these impersonal methods are the “right way” to communicate this information? What are some conditions that could justify firing someone via...