Pending the deal with Nagirok, ABC Co. would like to retire some high interest debt it has with another lender. Currently, ABC Co. has 7 years remaining on a 10 year loan. ABC Co current lender has agreed to accept the present value (PV) of the loan as payoff. Create an amortization schedule that shows how much ABC Co must pay at the end of each of the ten years. Create a worksheet that includes the beginning and ending balance, the amount paid on the principle, and the interest paid for years four through ten.

Youll need the following info to create the amortization schedule:

-Interest rate: 4.63%

-monthly payment: $4,488

Create a spreadsheet with the following cells and information for the loan details above. Note: you will have to determine the original loan amount.

This is an example:

Loan Amount	$243,141.25
Interest Rate	4.33%
Monthly Payment	$2,500
Year	Beginning Balance	End of Year Balance	Principle	Interest
1	$243,141.25	223,278.14	19,863.11	10,136.89
2	223,278.14	202,537.68	20,740.46	9,259.54
3	202,537.68	180,861.13	21,656.56	8,343.44
4	180,881.13	158,268.01	22,613.12	7,386.88
5	158,268.01	134,656.07	23,611.94	6,388.06
6	134,656.07	110,001.20	24,654.87	5,345.13
7	110,001.20	84,257.33	25,743.87	4,258.13
8	84,257.33	57,376.36	26,880.97	3,119.03
9	57,376.36	29,308.06	28,068.30	1,931.70
10	29,308.06	-	29,308.06	691.94

How would I get these answers, and what formulas would i use in excel to find each total? any help please.