In cell b8, create a formula without using a function that determines the total interest associated with the mortgage. first multiply the value in cell b6 (the number of terms) by the value in cell b7 (the number of monthly payments) and by 12 (to convert the yearly terms to monthly terms), and then subtract the value in cell b4 (the total loan amount).

the investment was $14,174.196

explanation:

a lump sum means that the father of the example made one deposit and leave it be.

we need to know the value of a capital that generated at 4.05% per year during 28 years the sum of $48,613.24

now clearing the formula to solve for capital we got:

and we reach the answer investment = $14,174.20

you will have $2593.74 in 10 years if you set aside $1,000 at 10%

you will have $9321.91 in 20 years if you set aside $2000 at 8%

you will have $1469.32 in 5 years if you set aside $1000 at 8%

you will have $1296.87 in 10 years if you set aside $500 at 10%

you will have $239.66 in 15 years if you set aside $100 at 6%

you will have $4660.96 in 20 years if you set aside $1000 at 8%

it's d. out with the planting and harvest of the crops.

answerblank(1) negatively.blank(2); rises; blank(3) falls;