During a recent brainstorming session, one of Franklin's co-workers suggested that their company could sell some of the data con
1 answer:
You might be interested in
Answer:
They need to put into the account a total of $67,290 to ensure that they will have $ 100,000 in 9 years.
Explanation:
We have to calculate the present value of the sum needed in 9 years ($100,000), with a annual fixed interest rate of 4.5%.
This can be calculated as:
They need to put into the account a total of $67,290 to ensure that they will have $ 100,000 in 9 years.
Answer:
=E7*C2/2
Explanation:
The interest expense will be the carrying value of the bond times the effective interest rate.
On cell C8 we have the interest expense
On E7 we have the carrying value which is the outstanding balance.
Then, on C2 we got the effective rate
As this is an annual formula, we must divide by two to convert to semiannual rate.
A file is attached for how the excel sheet looks like
