need help with highlighted parts in first table and i need input for ALL cells in the second table.

- Thanks!!

Use the appropriate finance function to calculate the missing information in the table below. Cheote a loan eption uvat you think will be optimal for the business and Grate an atnorvingtion whedule for the same. Choose a loan option that you think will be optimal for the business and eraata an amortization schedule for the same