Skip to main content
close
Font size options
Increase or decrease the font size for this website by clicking on the 'A's.
Contrast options
Choose a color combination to give the most comfortable contrast.
PMT Function

Financial Excel: Calculating Loan and Mortgage Payments

2023-12-18 17:00:00 2023-12-18 19:00:00 America/New_York Financial Excel: Calculating Loan and Mortgage Payments Martin Luther King Jr. Memorial Library - Central Library - 202-O Computer Lab (16 Person Capacity)

Monday, December 18
5:00pm - 7:00pm

Add to Calendar 2023-12-18 17:00:00 2023-12-18 19:00:00 America/New_York Financial Excel: Calculating Loan and Mortgage Payments Seats are limited to 16 participants and will be filled on a first-come, first-served basis. Please arrive a half-hour early to sign in for a seat at one of the 16 workstations. Martin Luther King Jr. Memorial Library - Central Library - 202-O Computer Lab (16 Person Capacity)

Martin Luther King Jr. Memorial Library - Central Library

202-O Computer Lab (16 Person Capacity)

Seats are limited to 16 participants and will be filled on a first-come, first-served basis. Please arrive a half-hour early to sign in for a seat at one of the 16 workstations.

In this two-hour class, you will learn to calculate the projected loan and mortgage payments at different prices and interest rates, using the Payment (PMT) Formula in Microsoft Excel 2019. 

Seats are limited to 16 participants and will be filled on a first-come, first-served basis. Please arrive a half-hour early to sign in for a seat at one of the 16 workstations.

For reasonable accommodation requests, please contact the Center for Accessibility at DCPLaccess@dc.gov or 202-727-2142.

Instructor: M. Rivera
MLK Jr. Memorial Library
Adult Learning Department
901 G Street, NW
Computer Lab - Room 202-O

Required skills: The ability to read and comprehend English well, and the skills acquired in PC Basics, Word I Basics, Word II Intermediate, Excel I Basics, Excel II Intermediate and Excel III Advanced.

You will learn to:

  • Calculate the payments on several different loan and mortgage payments
  • Engage the Function Arguments dialog box to enter and process the elements of the formula
  • Learn to navigate the Formulas Command Tab for related formulas 

Please bring your own flash drive to save class documents or send them to your email account.

AGE GROUP: | Seniors | Adults |

EVENT TYPE: | Computer Class |

TAGS: | |

Martin Luther King Jr. Memorial Library - Central Library

Phone: (202) 727-0321

Hours
Mon, Feb 26 9:30AM to 9:00PM
Tue, Feb 27 9:30AM to 9:00PM
Wed, Feb 28 9:30AM to 9:00PM
Thu, Feb 29 9:30AM to 9:00PM
Fri, Mar 01 9:30AM to 5:30PM
Sat, Mar 02 9:30AM to 5:30PM
Sun, Mar 03 1:00PM to 5:00PM

About the library

Upcoming events

Sat, Mar 02, All day

Sat, Mar 02, 10:00am - 12:00pm
205-B Accessibility Program Room

Sat, Mar 02, 1:00pm - 2:00pm

Sat, Mar 02, 2:00pm - 3:30pm

Mon, Mar 04, 10:00am - 12:00pm

Mon, Mar 04, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 04, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 04, 6:00pm - 8:00pm

Tue, Mar 05, 10:00am - 1:00pm
202-J Consultation Room

Tue, Mar 05, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Tue, Mar 05, 4:00pm - 5:00pm

Tue, Mar 05, 5:00pm - 9:00pm
Auditorium

Wed, Mar 06, 10:00am - 3:00pm

Wed, Mar 06, 10:00am - 12:00pm

Wed, Mar 06, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 06, 11:00am - 12:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 06, 12:15pm - 1:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 06, 1:30pm - 2:30pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 06, 1:30pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 06, 5:00pm - 6:00pm

Wed, Mar 06, 6:00pm - 8:00pm

Wed, Mar 06, 7:00pm - 8:00pm

Thu, Mar 07, 12:00pm - 1:00pm
Event Space

Thu, Mar 07, 12:00pm - 1:30pm
202-O Computer Lab (16 Person Capacity)

Thu, Mar 07, 12:00pm - 12:45pm
205-B Accessibility Program Room

Thu, Mar 07, 1:00pm - 3:00pm
202-J Consultation Room,202-K Consultation Room

Thu, Mar 07, 1:00pm - 2:00pm
205-B Accessibility Program Room

Thu, Mar 07, 2:00pm - 4:30pm
205-J Computer Lab (12 Person Capacity)

Thu, Mar 07, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Mar 07, 4:00pm - 6:00pm

Thu, Mar 07, 5:00pm - 6:00pm

Thu, Mar 07, 5:30pm - 9:00pm
Auditorium

Thu, Mar 07, 6:00pm - 8:00pm

Fri, Mar 08, 10:30am - 11:00am

Fri, Mar 08, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Mar 08, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Fri, Mar 08, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 09, 10:00am - 12:00pm
205-B Accessibility Program Room

Sat, Mar 09, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 09, 1:00pm - 2:30pm
East Storefront A & B

Sat, Mar 09, 1:00pm - 2:00pm

Sat, Mar 09, 2:00pm - 3:30pm
401-E Conference Room (20-46 Person Capacity)

Sat, Mar 09, 3:00pm - 5:00pm

Sun, Mar 10, 3:30pm - 4:30pm
East Storefront A & B

Mon, Mar 11, 10:00am - 12:00pm

Mon, Mar 11, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 11, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 11, 6:00pm - 8:00pm

Tue, Mar 12, 10:00am - 1:00pm
202-J Consultation Room

Tue, Mar 12, 11:30am - 12:00pm

Tue, Mar 12, 1:30pm - 3:00pm
401-G Conference Room (6-46 Person Capacity)

Tue, Mar 12, 2:00pm - 4:00pm
205-J Computer Lab (12 Person Capacity)

Tue, Mar 12, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Tue, Mar 12, 4:00pm - 5:00pm

Wed, Mar 13, 10:00am - 3:00pm

Wed, Mar 13, 10:00am - 12:00pm

Wed, Mar 13, 10:30am - 12:00pm
Auditorium

Wed, Mar 13, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 13, 11:00am - 12:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 13, 12:15pm - 1:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 13, 1:30pm - 2:30pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 13, 5:00pm - 6:00pm

Wed, Mar 13, 6:00pm - 8:00pm

Thu, Mar 14, 12:00pm - 12:45pm
205-B Accessibility Program Room

Thu, Mar 14, 1:00pm - 2:00pm
205-B Accessibility Program Room

Thu, Mar 14, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Thu, Mar 14, 2:00pm - 4:30pm
205-J Computer Lab (12 Person Capacity)

Thu, Mar 14, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Mar 14, 4:00pm - 6:00pm

Thu, Mar 14, 5:00pm - 6:00pm

Fri, Mar 15, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Mar 15, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Fri, Mar 15, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 16, 10:00am - 12:00pm
205-B Accessibility Program Room

Sat, Mar 16, 10:30am - 12:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 16, 1:00pm - 2:00pm

Sat, Mar 16, 1:00pm - 2:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 18, 10:00am - 12:00pm

Mon, Mar 18, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 18, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 18, 6:00pm - 8:00pm

Mon, Mar 18, 6:30pm - 8:00pm
401-G Conference Room (6-46 Person Capacity)

Tue, Mar 19, 10:00am - 1:00pm
202-J Consultation Room

Tue, Mar 19, 2:00pm - 4:00pm
205-J Computer Lab (12 Person Capacity)

Tue, Mar 19, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Tue, Mar 19, 4:00pm - 5:00pm

Wed, Mar 20, 10:00am - 3:00pm

Wed, Mar 20, 10:00am - 12:00pm

Wed, Mar 20, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 20, 11:00am - 12:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 20, 12:15pm - 1:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 20, 1:30pm - 2:30pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 20, 1:30pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 20, 5:00pm - 6:00pm

Wed, Mar 20, 6:00pm - 8:00pm

Thu, Mar 21, 12:00pm - 12:45pm
205-B Accessibility Program Room

Thu, Mar 21, 1:00pm - 2:00pm
205-B Accessibility Program Room

Thu, Mar 21, 2:00pm - 4:30pm
205-J Computer Lab (12 Person Capacity)

Thu, Mar 21, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Thu, Mar 21, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Mar 21, 4:00pm - 6:00pm

Thu, Mar 21, 5:00pm - 6:00pm

Fri, Mar 22, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Mar 22, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Fri, Mar 22, 12:00pm - 1:00pm
Great Hall

Fri, Mar 22, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 23, 10:30am - 12:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 23, 1:00pm - 2:00pm

Sat, Mar 23, 1:00pm - 3:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 23, 2:00pm - 4:00pm
401-A Conference Room (20-50 Person Capacity)

Mon, Mar 25, 10:00am - 12:00pm

Mon, Mar 25, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 25, 5:30pm - 7:30pm
202-O Computer Lab (16 Person Capacity)

Mon, Mar 25, 6:00pm - 8:00pm

Mon, Mar 25, 7:00pm - 9:00pm

Tue, Mar 26, 10:00am - 1:00pm
202-J Consultation Room

Tue, Mar 26, 2:00pm - 4:00pm
205-J Computer Lab (12 Person Capacity)

Tue, Mar 26, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Tue, Mar 26, 4:00pm - 5:00pm

Wed, Mar 27, 10:00am - 3:00pm

Wed, Mar 27, 10:00am - 12:00pm

Wed, Mar 27, 11:00am - 12:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 27, 12:15pm - 1:15pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 27, 1:30pm - 2:30pm
205-J Computer Lab (12 Person Capacity)

Wed, Mar 27, 1:30pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 27, 5:00pm - 6:00pm

Wed, Mar 27, 5:00pm - 7:00pm
202-O Computer Lab (16 Person Capacity)

Wed, Mar 27, 5:30pm - 7:00pm

Wed, Mar 27, 6:00pm - 8:00pm

Wed, Mar 27, 7:00pm - 8:00pm
East Storefront A & B

Thu, Mar 28, 12:00pm - 12:45pm
205-B Accessibility Program Room

Thu, Mar 28, 1:00pm - 2:00pm
205-B Accessibility Program Room

Thu, Mar 28, 2:00pm - 4:30pm
205-J Computer Lab (12 Person Capacity)

Thu, Mar 28, 2:00pm - 3:30pm
202-O Computer Lab (16 Person Capacity)

Thu, Mar 28, 2:15pm - 3:15pm
205-B Accessibility Program Room

Thu, Mar 28, 5:00pm - 6:00pm

Thu, Mar 28, 6:30pm - 8:30pm
401-C Program Room (People's Archive)

Thu, Mar 28, 7:00pm - 9:00pm
East Storefront A & B

Fri, Mar 29, 10:30am - 12:00pm
205-B Accessibility Program Room

Fri, Mar 29, 11:00am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Fri, Mar 29, 3:00pm - 5:00pm

Sat, Mar 30, 10:30am - 12:30pm
202-O Computer Lab (16 Person Capacity)

Sat, Mar 30, 1:00pm - 2:30pm
401-A Conference Room (20-50 Person Capacity)

Sat, Mar 30, 1:00pm - 2:00pm

Sat, Mar 30, 2:00pm - 4:00pm
202-O Computer Lab (16 Person Capacity)

Mon, Apr 01, 10:00am - 12:00pm

Mon, Apr 01, 6:00pm - 8:00pm