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-04 17:00:00 2023-12-04 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 04
5:00pm - 7:00pm

Add to Calendar 2023-12-04 17:00:00 2023-12-04 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 19 9:30AM to 5:30PM
Tue, Feb 20 9:30AM to 9:00PM
Wed, Feb 21 9:30AM to 9:00PM
Thu, Feb 22 9:30AM to 9:00PM
Fri, Feb 23 9:30AM to 5:30PM
Sat, Feb 24 9:30AM to 5:30PM
Sun, Feb 25 1:00PM to 5:00PM

About the library

Upcoming events

Sat, Feb 24, 10:00am - 12:00pm
205-B Accessibility Program Room

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

Sat, Feb 24, 11:00am - 12:30pm
Registration is now closed

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

Sat, Feb 24, 1:00pm - 2:30pm

Sat, Feb 24, 1:00pm - 2:00pm

Sat, Feb 24, 1:30pm - 3:00pm
202-O Computer Lab (16 Person Capacity)

Sat, Feb 24, 1:30pm - 3:30pm

Mon, Feb 26, 10:00am - 12:00pm

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

Mon, Feb 26, 4:00pm - 5:00pm

Mon, Feb 26, 5:00pm - 7:00pm
202-O Computer Lab (16 Person Capacity)

Mon, Feb 26, 6:00pm - 8:00pm

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

Tue, Feb 27, 10:00am - 1:00pm
202-J Consultation Room

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

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

Tue, Feb 27, 4:00pm - 5:00pm

Tue, Feb 27, 5:00pm - 9:00pm
Auditorium

Tue, Feb 27, 6:00pm - 7:30pm

Wed, Feb 28, 10:00am - 3:00pm

Wed, Feb 28, 10:00am - 12:00pm

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

Wed, Feb 28, 2:00pm - 4:00pm

Wed, Feb 28, 4:30pm - 6:30pm
202-O Computer Lab (16 Person Capacity)

Wed, Feb 28, 5:00pm - 6:00pm

Wed, Feb 28, 5:30pm - 7:00pm

Wed, Feb 28, 6:00pm - 8:00pm

Wed, Feb 28, 6:00pm - 7:30pm

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

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

Thu, Feb 29, 4:00pm - 6:00pm

Thu, Feb 29, 5:00pm - 6:00pm

Thu, Feb 29, 5:00pm - 7:00pm
204-F Youth Program Room

Thu, Feb 29, 7:00pm - 8:00pm
East Storefront A & B

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

Fri, Mar 01, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity)

Fri, Mar 01, 3:30pm - 5:00pm

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, 6:00pm - 8:00pm

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

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, 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, 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: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, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity)

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

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, 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, 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, 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: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, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity)

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

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

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

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, 4:00pm - 5:00pm

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

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

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, 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: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, 11:00am - 12:00pm
401-G Conference Room (6-46 Person Capacity)

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

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, 6:00pm - 8:00pm

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