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
Answer:
the second option
Explanation:
Present value is the sum of discounted cash flows
Present value can be calculated using a financial calculator
first option
Cash flow in year 1 and 2 - $85,000
1 = 7
PV = $153,681.54
Second option
Cash flow in year 0 = $20,000
Cash flow in year 1 and 2- $74,000
I = 7
PV = $153,793.34
the pv of the second payment is higher than the first so the seconf would be choosen
To find the PV using a financial calculator:
1. Input the cash flow values by pressing the CF button. After inputting the value, press enter and the arrow facing a downward direction.
2. after inputting all the cash flows, press the NPV button, input the value for I, press enter and the arrow facing a downward direction.
3. Press compute
153,681.54
This is a positive statement
Answer: $143,000
Explanation:
Accrual Income for the year = Cash from clients + Closing receivable balance - Opening receivable balance - Salaries - (Utilities - Opening utilities owed + closing utilities owed) - Advertising
= 420,000 + 60,000 - 52,000 - 240,000 - (35,000 - 6,000 + 4,000) - 12,000
= $143,000
