ITBA Activity 1 (Case Study)
EXCEL BASICS
Case Background:
A credit application is a standardized form that a customer or borrower uses to request credit. The document
contains requests for such information as:
- The amount of credit requested
- The identification of the applicant
- The financial status of the applicant
- The names of credit references
- Standard terms and conditions
A supplier or lender issues the credit application form to standardize the information it uses to make credit decisions.
Additional information may be used in making a credit decision, such as a credit report from a credit rating agency and
information received from the credit references supplied by the applicant.
Based on the information in a completed form, a credit analyst may elect to grant or deny credit or impose additional
conditions, such as a personal guarantee or collateral. The granting of credit through an online form is highly automated,
so that the entire process may only require a few minutes to complete.
A new bank hired you to create and design a CREDIT APPLICATION FORM using Microsoft Excel. The bank wants you to
include the following details:
Referral Information: ▪ House and Lot
▪ Townhomes
- Unit/Branch
▪ Condominium
- Broker
▪ Commercial Building
Loan Details: ▪ Mixed Commercial/Residential
▪ Others
- Loan Amount - Collateral 2
- Term o Property Address
- Fixing Period o Present Registered Owner
- Purpose of Loan o Contact Person
o Working Capital o Contact Number
o Acquisition of Property/Business o Type of Collateral
o Construction or Renovation ▪ Lot only
o Refinancing of Business Loan ▪ House and Lot
o Purchase of Fixed Assets or Equipment ▪ Townhomes
o Business Expansion ▪ Condominium
o Others (Please specify) ▪ Commercial Building
Collateral Details: ▪ Mixed Commercial/Residential
▪ Others
- Collateral 1
o Property Address
o Present Registered Owner
o Contact Person
o Contact Number
o Type of Collateral
▪ Lot only
Borrowers Information: - Tel No
- Cellphone NO
- Name
- Email Address
o First
o Last Business/Employment Details:
o Middle
- Employed
- SSS/GSIS NO
o Employer Type
- TIN
▪ Private
- Company Name
▪ Government
- Birthdate
▪ Immigrant/OFW
- Birthplace
o Employer
- Citizenship
o Tel./Fax No
- Gender
o Address
o Male
o Position
o Female
o Years of Employment
- Civil Status
o Nature of Business
o Single
- Business
o Married
o Type of Business
o Widow/er
▪ Single Proprietorship
o Separated
▪ Partnership
- No of dependents
▪ Corporation
- Highest Educational Attainment
o Business Name
- Present Address
o Tel./Fax No
- Residence is
o Address
o Owned
o Years in operation
o Rented
o Nature of Business
o Living with Parents/Relatives
Please include a Borrower signature over the printed name field, including the date at the end of your proposed form.
Be creative in designing your Loan Application form. You can add a logo or a header (Give the bank a name) and
make it colorful (but not too colorful, balance design and readability). Use the different formatting tools and techniques
in our class notes. You can base your forms on existing forms found on the internet, but please do not copy outright.
Again, you need to include all of the details above.
Save your Excel file with the following format:
Lastname_FistnamePACT01.xlsx
