Reference no: EM13131961
Develop a loan amortization project using Excel spreadsheets. This can be a car loan or a home mortgage. You will develop two alternative loan schedules using realistic rates and repayment schedules and write up a comparison of your two amortization schedules. This involves two tables and two line graphs displaying the decrease in principal.
1. Open the spreadsheet, plan which two loans you want to compare.
2. Fill in the cells for loan amount, rate, and years for the loan.
3. Create two line graphs for the ending balance. Please label the bottom or x axis and the left of the graph or y axis. Write a title across the top.
4. Use the CTRL button to select years and ending balance COLUMNS
5. Insert a line graph, choose the first picture of a line graph. REPEAT for the second loan.
6. Delete the blue points from the graph, label the left side "Ending Balance".
7. In Microsoft Word, write about the trends you see in the amortization table in two paragraphs. My Suggestions: Write another two paragraphs about the second amortization table. Then write your last two paragraphs comparing the two tables.
|
Define lethality of carbon monoxide
: Lethality of Carbon Monoxide, Sulfur Dioxide and TNT Air monitoring provides the following contaminant concentrations at the approximate center of a fire scene in which acres of automobile tires are burning:
|
|
Find how high must student score be to win award
: Student who scores in the top 5% of statewide scores. How high should a student score be to win this award? Give your answer to the nearest integer.
|
|
Proof equivalent cauchy sequences
: Show that if (a_n)^infinity evaluated at n=1, and (b_n)^infinity evaluated at n=1 are equivalent sequences of rationals, then (a_n) ^infinity evaluated at n=1 is a cauchy sequence if and only if (b_n)^infinity evaluated at n=1 is a cauchy sequence..
|
|
Caluculate the amount of dividends actually paid
: Clifford Company's comparative balance sheet included dividends payable of $80,000 at December 31, 2009, and $100,000 at December 21, 2010. Dividends declared by Clliford during 2010 amounted to $400,000.
|
|
Loan amortization schedule comparison project
: Develop a loan amortization project using Excel spreadsheets. This can be a car loan or a home mortgage. You will develop two alternative loan schedules using realistic rates and repayment schedules and write up a comparison of your two amortizati..
|
|
Difference between discount bond versus a premium bond
: A firm issues $100,000 par value of bonds in which the coupon rate is 10% and the yield to maturity is 12%. Assume this firm has $20,000 in operating cash flow before the bond issue. Discuss the influence the bond issue would have on the balance s..
|
|
Define chemical structure and hydrogen bonds in base pairs
: Chemical Structure and Hydrogen Bonds in Base Pairs, Draw the chemical structure of a correctly base paired G-C pair, then re-draw the pair with a propeller twist these answers should all be on one page following box 'G'
|
|
Company raw material inventory account
: It's Kinda China produces collectible pieces of act. The company's Raw Material Inventory account includes the cost of both direct and indirect materials. Account balances for the company at the beginning and end of July 2008 follow:
|
|
Find the frequency function for total number of attempts
: The outcomes of the successive trials are assumed to be independent. Find the frequency function for the total number of attempts. What is the probability that player A wins?
|