Mr. Marcos is interested in buying a 4x4 truck. If the cash vehicle has a price of 999,900 and pays a down payment of 650,000. With this information prepare a quote. However, when leaving the agency, a rain falls and wets the document where the monthly payment amount becomes illegible. Solve the following paragraph step by step Nissan Frontier Pickup 2022 v6 pro cash price: $999900 to hook: $650000 Financing: $349900.00 Monthly payment: $ xxxxxxxxxx Place: 60 months Annual rate: 11.76% a) calculate with mathematical formulas the partial monthly payment with VAT (16%), payment interest (from period 20) and VAT on interest (from period 20) b) Check by recalculating with formulas the capital (amount financed) and the number of periods (60) c) Prepare the amortization table in excel including VAT