How do i calculate, is there a formula for excel?
The school you would like to attend costs $100,000. To help finance your education, you need to choose whether or not to sell any of your 500 shares of Apple stock you bought five years ago, 100 Apple bonds (each with a $1,000 face value and a 3.25% coupon rate) that are five years from their 10-year maturity date, or a combination of both. Provide the appropriate data and calculations that you would perform to make this decision
Sample Solution
