Case A - You have decided to start planning for your retirement. You already have $11,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Case A - You have decided to start planning for your retirement. You already have $11,000 in your investment account. You plan to put an additional $4,000 into the account at the BEGINNING of each year for the next 10 years and then put $6,000 into the account at the BEGINNING of each of the following 30 years. Your account is expected to grow at 6.5% interest (tax free) annually. Prepare a schedule to show (1.) the year (1 through 40), (2.) the beginning balance each year, (3.) the amount of interest earned each year, (4.) the deposit each year, and (5.) the ending balance each year. Format each of the dollar amounts with two decimals. Please include totals at the bottom of your spreadsheet for (1) the amount of interest and (2) the amount of deposits during the entire 40 year (10 + 30) year time. Case B-You estimate that you will have $43,000 of school loans by the time you graduate. Your school loan is to be paid off over 10 years but you plan to pay it off over a 4 year period with payments being made at the END of each MONTH for the 4 years following graduation. Assume your school loans charge 6% interest compounded MONTHLY. Prepare a schedule to show (1) the month number (i.e. #1 - #48), (2) the beginning loan balance each month, (3) the payment each month, (4) the amount of interest in each monthly payment, (5) the amount of principal in each monthly payment, and (6) the ending balance each month. Format each of the amounts with two decimals. Please include totals at the bottom of your spreadsheet for (1) the amount of payments, (2) the amount of interest, and (3) the amount of principal which was paid during the 48 month term of the loan. Case A - You have decided to start planning for your retirement. You already have $11,000 in your investment account. You plan to put an additional $4,000 into the account at the BEGINNING of each year for the next 10 years and then put $6,000 into the account at the BEGINNING of each of the following 30 years. Your account is expected to grow at 6.5% interest (tax free) annually. Prepare a schedule to show (1.) the year (1 through 40), (2.) the beginning balance each year, (3.) the amount of interest earned each year, (4.) the deposit each year, and (5.) the ending balance each year. Format each of the dollar amounts with two decimals. Please include totals at the bottom of your spreadsheet for (1) the amount of interest and (2) the amount of deposits during the entire 40 year (10 + 30) year time. Case B-You estimate that you will have $43,000 of school loans by the time you graduate. Your school loan is to be paid off over 10 years but you plan to pay it off over a 4 year period with payments being made at the END of each MONTH for the 4 years following graduation. Assume your school loans charge 6% interest compounded MONTHLY. Prepare a schedule to show (1) the month number (i.e. #1 - #48), (2) the beginning loan balance each month, (3) the payment each month, (4) the amount of interest in each monthly payment, (5) the amount of principal in each monthly payment, and (6) the ending balance each month. Format each of the amounts with two decimals. Please include totals at the bottom of your spreadsheet for (1) the amount of payments, (2) the amount of interest, and (3) the amount of principal which was paid during the 48 month term of the loan.
Expert Answer:
Answer rating: 100% (QA)
CASEA Here I have considered interest is reinvested in such account Please go through the table below SL NO YEAR Opening balance AMOUNT INTEREST 65 TOTAL 1 1 1100000 400000 97500 1597500 2 2 1597500 4... View the full answer
Related Book For
Contemporary Financial Management
ISBN: 9780324289114
10th Edition
Authors: James R Mcguigan, R Charles Moyer, William J Kretlow
Posted Date:
Students also viewed these accounting questions
-
You have decided to start planning for your retirement by analyzing different retirement plans. The plan offered by IRA Managers requires you to deposit $5,000 at the beginning of each of the next 30...
-
You have decided to spend $40 this month on CDs and movies. The total benefits you receive from different quantities of CDs and movies are shown in the table below. The price of a CD is $10 and the...
-
A company deposits $12,000 at the beginning of each quarter into an account that earns 7.2% compounded quarterly. How much will be in this account after 5 years? (a) State whether the problem relates...
-
The enzyme Stell participates in several distinct MAP kinase signaling pathways in the budding yeast S. cerevisiae. What is the substrate for Ste 11 in the mating factor signaling pathway? When a...
-
Do alcoholic beverage companies fulfill their ethical duty to be informative and truthful in advertising? Do they generally uphold their ethical duty to minimize potential harm to society from...
-
A venturi meter is a device placed in a pipeline to allow for the measurement of flow through that pipeline. As shown in the following figure, the meter consists of a tapered reduction of the pipe...
-
Rods \(A B\) and \(A C\) have a diameter of \(20 \mathrm{~mm}\) and are made of 6061-T6 aluminum alloy. They are connected to the rigid collar \(A\) which slides freely along the vertical guide rod....
-
Consider the following two situations'cases A and B' independently. Data refer to operations for April 2012. For each situation, assume standard costing. Also assume the use of a flexible budget for...
-
Sheldon saw the same commercial that Leonard saw in Leonard v. Pepsico, Inc. He wanted the Pepsi leather jacket for 1,450 Pepsi pointswhich he could earn by purchasing 1,450 individual Pepsi bottles...
-
The Foxridge Investment Group buys and sells rental income properties in southwest Virginia. Bill Hunter, president of Foxridge, has asked for your assistance in analyzing a small apartment building...
-
Use the bar graph from the World View "GDP per Capita around the World" to answer two questions. 63,080 47,090 44,940 41,310 30,600 GDP per capita (2018) (in U.S. dollars) 21,600 11,124 10,230 9,460...
-
In January 2000, shortly before the bursting of the tech/internet bubble, one of the largest media conglomerates in the world was created when America Online Inc. (AOL), the world's largest internet...
-
Fresh Water, Inc. Executed the sale of a series of 30-year bonds with a par value of $1,000 to the general public. The bonds offer an annual coupon rate of 10.63 percent, with interest payments made...
-
To buy a truck, a company can opt for a loan under the following conditions: pay for 7 years equal installments of 550,000 at the end of each two-month period at an effective bimonthly interest rate...
-
2-Discuss the benefits and potential challenges of recognizing religious diversity in the workplace .
-
1. What can charisma do for you? 2. What are the characteristics of charisma? 3. What are the clues of power? 4. What inhibits power? 5. How do you dismantle the 'imposter' syndrome? 6. Why are the...
-
The sanitation department of a large city wants to investigate ways to reduce the amount of recyclable materials that are placed in the city s landfill. The city hopes to prolong the life of the...
-
On August 31, 2012, the balances of the accounts appearing in the ledger of Wood Interiors Company, a furniture wholesaler, are as follows:Prepare the August 31, 2012, closing entries for Wood...
-
The Findlay Company has debentures outstanding (par value = $1,000) that are convertible into common stock at a price of $50 per share. The convertible bonds have a coupon interest rate of 9 percent...
-
Torbet Fish Packing Company wants to accumulate enough money over the next 10 years to pay for the expected replacement of its digitalized, automated scaling machine. The new machine is expected to...
-
Define float and describe the difference between disbursement float and deposit float.
-
Consider a scenario where an online trade application is being developed. The two registered users can negotiate over the price of a product being traded. Create a class diagram for this application...
-
Consider a scenario where you negotiate with a company over the salary and perks being offered for a position. Create a class diagram for this using negotiation patterns as your base and draw a...
-
What are the three foundation concepts of stability model?
Study smarter with the SolutionInn App