Cortesia
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Cortesia as PDF for free.
More details
- Words: 231
- Pages: 1
SAMPLE SPOT PAYMENT COMPUTATION
SPOT CAMPAIGN (Note: You just need to fill in the following data highighted in YELLOW and automatically the excel will compute the discounts) TCP MCC & VAT
3,000,000 360,976 2,439,024 360,976
SPOT CON DISCOUNT RATE SPOT DP DISCOUNT RATE SPOT CASH DISCOUNT RATE RESERVATION FEE
SPOTCASH SPOTCASH
10% 15% 15% 40,000
3,000,000
DEFERRED CASH 20% SPOT DP
600,000
IN-HOUSE 20% SPOT DP
600,000
LESS MCC (the whole MCC amount) RES FEE NET CONTRACT PRICE DISCOUNT RATE
360,976 40,000 2,599,024 15%
LESS MCC (20% of the MCC amount) RES FEE NET CONTRACTING AMOUNT DISCOUNT RATE
72,195 40,000 487,805 15%
LESS MCC (20% of the MCC amount) RES FEE NET CONTRACTING AMOUNT DISCOUNT RATE
72,195 40,000 487,805 15%
DISCOUNT AMOUNT
389,854
DISCOUNT AMOUNT
73,171
DISCOUNT AMOUNT
73,171
BALANCE TO BE PAID SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
BALANCE TO BE PAID 3,000,000 40,000 389,854
2,570,146
NOTE: BALANCE IS PAYABLE WITHIN 7 DAYS FROM THE RESERVATION DATE
SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
BALANCE TO BE PAID 600,000 40,000 73,171
486,829
SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
600,000 40,000 73,171
486,829
NOTE: BALANCE IS PAYABLE WITHIN THE MONTH OF RESERVATION
NOTE: BALANCE IS PAYABLE WITHIN THE MONTH OF RESERVATION
80% BALANCE
80% BALANCE
MONTHLY AMORTIZATION (18 MONTHS W/O INTEREST)
2,400,000 133,333
5 YRS IN HOUSE FINANCING @ 19% INTEREST
2,400,000 62,258
SPOT CAMPAIGN (Note: You just need to fill in the following data highighted in YELLOW and automatically the excel will compute the discounts) TCP MCC & VAT
3,000,000 360,976 2,439,024 360,976
SPOT CON DISCOUNT RATE SPOT DP DISCOUNT RATE SPOT CASH DISCOUNT RATE RESERVATION FEE
SPOTCASH SPOTCASH
10% 15% 15% 40,000
3,000,000
DEFERRED CASH 20% SPOT DP
600,000
IN-HOUSE 20% SPOT DP
600,000
LESS MCC (the whole MCC amount) RES FEE NET CONTRACT PRICE DISCOUNT RATE
360,976 40,000 2,599,024 15%
LESS MCC (20% of the MCC amount) RES FEE NET CONTRACTING AMOUNT DISCOUNT RATE
72,195 40,000 487,805 15%
LESS MCC (20% of the MCC amount) RES FEE NET CONTRACTING AMOUNT DISCOUNT RATE
72,195 40,000 487,805 15%
DISCOUNT AMOUNT
389,854
DISCOUNT AMOUNT
73,171
DISCOUNT AMOUNT
73,171
BALANCE TO BE PAID SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
BALANCE TO BE PAID 3,000,000 40,000 389,854
2,570,146
NOTE: BALANCE IS PAYABLE WITHIN 7 DAYS FROM THE RESERVATION DATE
SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
BALANCE TO BE PAID 600,000 40,000 73,171
486,829
SPOT CON AMOUNT LESS RES FEE DISCOUNT AMOUNT
BALANCE
600,000 40,000 73,171
486,829
NOTE: BALANCE IS PAYABLE WITHIN THE MONTH OF RESERVATION
NOTE: BALANCE IS PAYABLE WITHIN THE MONTH OF RESERVATION
80% BALANCE
80% BALANCE
MONTHLY AMORTIZATION (18 MONTHS W/O INTEREST)
2,400,000 133,333
5 YRS IN HOUSE FINANCING @ 19% INTEREST
2,400,000 62,258
Related Documents
Cortesia
May 2020 6
Cortesia Y Amabilidad.docx
December 2019 9
Grammatica Italiana - Forme Di Cortesia
December 2019 17
