by excel

Inc. company raised capital using as follows: - a six year loan was obtained in 2020 from a local bank - an eight year bond was issued in 2019 Based on this information answer the following: A-Show the yearly loan payments using an amortization schedule for a loan of 50000000(50m) if you know the rate is 11% and the duration of the loan is 6 years. B- Show the yealy amoritaztion schedule for 50000 (50K) bonds with a face value of 1000, YTM of 9%, maturity of 8 years, and coupon rate of 11%. C- Complete the income statment and balance sheet for the company if the tax rate is 20% (number in millions). D- What is the value of the bond today (June, 2023)