Question: please solve using excel. need formulas Amount per month in option 1 6,100 $ Amount per month in option 2 2 Signing bonus in option




Amount per month in option 1 6,100 $ Amount per month in option 2 2 Signing bonus in option 2 5,100 25,000 APR 7% Output area Monthly interest rate Present value of option 1 Present value of option 2 Diffference in PV Future value of option 1 Future value of option 2 Difference in FV M N Salary for 2 years ago Last year's salary Future salary Years for future salary Pain and suffering Court costs EAR $ 44,000 $ 47.000 $ 51,000 5 $ 200,000 $ 25,000 7% Output area APR HINT value at the end of prior year two at the start of the prior year one HINT use the value calculated in the immediate above cell FV of salary 2 years ago Value today of salary 2 years ago Value today of last year's salary Value of next 5 year's salary Total value awarded Input area: Years to maturity Coupons per year Bond price Face value Yield to maturity $ 12 1. 1,030 1,000 6.14% A Output area: Coupon payment Coupon rate Input area $ Invoice price Coupon rate Months to next coupon Par value 1,043.00 4.7% 5 1,000 $ Output area: Accrued interest Clean price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
