Answer:
The closing balance from the excel sheet is $5,000.00
Explanation:
Solution
Given that:
The loan balance required l for each month can be computed as follows:
The loan balance = additional cash needed – cash used to retire debt + loan balance from previous month
Now
By applying the excel formula to perform this task is stated as follows:
D34 = SUM(D31-D33,C34)
The same formula is used to get the values for E34 to I34.
Kindly find an attached copy of the updated excel sheet after applying above formula which is a part of the solution is as follows:
Answer: $26; $28.057
Explanation:
Total value = $260 million in assets
Shares outstanding = 10 million
Dividends = $2.5 million
Fund value at the start of the year =
=
= $26
Fund value at the end of the year:
Dividend per share =
=
= $0.25
Price gain at 9% with deduction of 1% of 12b-1
Fund value at the end of the year = $26 × 1.09 × (1 - 0.01)
= $28.057
Answer:
less desirable to other investors
Explanation:
<u>Given</u>: Current fixed coupon rate 5%
Market rate of interest 5%
New Market Rate of Interest 6%
Value of a bond is inversely related to economy interest rate or the yield to maturity (YTM). Value of a bond is expressed by the following equation:
wherein, C = Coupon rate of interest
YTM = Market Rate of Interest or interest rate in the economy or investor's expectation
n= Years to maturity
RV = Redemption value
In the given case, C = YTM i.e par value bond. When ytm rises to 6%, the value of the bond shall fall making such a bond less attractive since it represents lower coupon payments than investor expectations.
Thus, now the bond would be less desirable to other investors.