Complete the following problems using an Excel spreadsheet.–1) What equal annual series of payments must be paid into a sinking fund in order to accumulate $12,500 in 8 years at 10% compounded annually? 2) Your company wants to set aside a fixed amount every year to a sinking fund to replace a piece of industrial equipment costing $150,000 at the end of five years from now. The sinking fund is expected to earn 8% interest. How much must the company deposit each year to meet this goal? 3) You deposit $1,250 today, $1,250 one year from now, and $3,000 three years from now. How much money do you have at the end of year 3 if there are different annual compound-interest rates per period? 4) A company borrowed $150,000 at an interest rate of 6% compounded annually over six years. The loan will be repaid in installments at the end of each year according to the accompanying repayment schedule. What will be the size of the last payment (X) that will pay off the loan? 5) What is the present worth of a series of payments of $6,000 at the end of each year for eight years at 7% compounded annually? 6) What is the future worth of a series of payments of $5,250 at the end of each year for ten years at 8% compounded annually?– All of the text in this assignment needs to be set in 10 or 12-point size. Please resist the temptation to mix and match point sizes. If you doubt your applications intentions, just select all of your text and insure that it is in 10 or 12-point size. The right and left side can be set for ½” (0.5) margins. Set the top and bottom margins to one (1”). The only text that ends up on the outside of the one-inch margin is the page number. Remember to do your spelling and grammar checking before turning your assignments in. When doing the spelling/grammar checking keep in mind that some words such as mush and must, woods and words, or here and cow, will not be caught by either check. To correct these problems, you will need to proofread your work. Any homework that has more than one page needs to have page numbers on it. Please place your page numbers on the bottom of the page. In MS Excel, use the footer selection and place the page number the or of the page. List each problem’s number on the left, placing a blank cell above it.Write the problem exactly as appears in the book immediately below the problem number. You will need to break long text up between cells so that you will stay with-in the printing boundaries of the page. Skip one cell and write the word “Given:” Follow that with what is known from the problem. If the problem has multiple parts, place the letter of each part before the “Given”. Skip one cell and write the word “Find:” Follow that with what the problem wants solved. If the problem has multiple parts, place each “Find” below each “Given”. Skip one cell and write the formula that you will be using. Be sure to place it inside quotation marks so that excel does not think that it is an active formula. In the next lower cell and write the formula that you will be using with the values placed into it. Be sure to place it inside quotation marks so that excel does not think that it is an active formula. In the next lower cell and write the formula that you will be using with the values placed into it. , as this is where you place the active formula. When working with uneven payment series, break the problem down into sections, solve for each, and then sum them together to get your final answer.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.
[order_calculator]