Loading…
Loading…
What you will build: A loan summary driven by a named rate, a 12-month amortization schedule, the year-one interest, the effect of overpaying, an affordability check and data bars on the principal.
Finance
A couple is buying a 350,000 home with a 15% deposit and a 25-year mortgage at 5.5%. Build them a calculator: the monthly payment, what the loan really costs, how the first year of payments splits between interest and principal, how much an extra 200 a month saves, and the biggest loan their 1,800 monthly budget could support. Every number must come from the inputs so they can try other scenarios.
Premium includes all 12 projects, every advanced lesson and certificates. Already Premium? Sign in to open it.
A loan summary driven by a named rate, a 12-month amortization schedule, the year-one interest, the effect of overpaying, an affordability check and data bars on the principal. Every step is checked automatically, with hints when you get stuck.
B8: the amount borrowed: home price × (1 − deposit %).
5 points
Name B4 AnnualRate with the Name Box. Then in B9, use PMT with AnnualRate/12, the number of months and the loan in B8 to get the monthly payment (positive).
15 points
B10: total paid over the whole term. B11: total interest (total paid − loan).
10 points
E2 = the loan (B8); E3:E13 = the previous month’s Closing. F: Opening × AnnualRate ÷ 12. G: the monthly payment (B9) − interest. H: Opening − principal. Fill rows 2 to…
25 points
B13: total interest paid in the first 12 months (from the schedule).
10 points
B14: months to repay if they pay the normal payment plus the extra in B6 (NPER). B15: months saved compared with the full term.
15 points
B18: the largest loan their monthly budget in B17 could repay over the same term and rate (PV, positive).
10 points
Add data bars to G2:G13 to show the principal share rising each month.
10 points
New to any of these? Each one is a free or Premium lesson you can do first.
FluentExcel project · Healthcare
Hospital Administration
8 steps · 120 rows of data · 380 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Patient | Admitted | Discharged | Department | Age | Cost | Insured | Stay (days) | Age group | Admit day |
| 2 | PT-5017 | 1/2/2026 | 1/7/2026 | Orthopedics | 39 | $6,735 | Yes | 5 | Adult | Weekday |
| 3 | PT-5035 | 1/2/2026 | 1/14/2026 | Oncology | 22 | $30,965 | Yes | 12 | Adult | Weekday |
| 4 | PT-5052 | 1/2/2026 | 1/10/2026 | Orthopedics | 28 | $10,498 | Yes | 8 | Adult | Weekday |
| 5 | PT-5099 | 1/3/2026 | 1/6/2026 | Cardiology | 35 | $7,902 | Yes | 3 | Adult | Weekend |
| 6 | PT-5107 | 1/3/2026 | 1/8/2026 | General | 58 | $8,386 | Yes | 5 | Adult | Weekend |
| 7 | PT-5106 | 1/4/2026 | 1/6/2026 | General | 68 | $2,491 | Yes | 2 | Senior | Weekend |
| 8 | PT-5110 | 1/4/2026 | 1/10/2026 | Oncology | 54 | $13,138 | Yes | 6 | Adult | Weekend |
| 9 | PT-5031 | 1/5/2026 | 1/10/2026 | Orthopedics | 58 | $8,380 | Yes | 5 | Adult | Weekday |
| 10 | PT-5008 | 1/6/2026 | 1/18/2026 | Oncology | 37 | $31,105 | No | 12 | Adult | Weekday |
| 11 | PT-5023 | 1/6/2026 | 1/10/2026 | Pediatrics | 17 | $4,176 | Yes | 4 | Child | Weekday |
Patients by department
Healthcare
Hospital Administration
8 steps · 3 h
FluentExcel project · Real estate
Real Estate Analysis
10 steps · 60 rows of data · 66 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Listing | Neighborhood | Type | Beds | SqFt | Price | Days on market | Price/SqFt | Summary | |
| 2 | RE-1029 | Downtown | House | 4 | 2540 | $1,235,000 | 108 | 486.2204724 | Total value | |
| 3 | RE-1001 | Downtown | Condo | 5 | 2900 | $1,185,000 | 9 | 408.6206897 | Average price | |
| 4 | RE-1054 | Downtown | Townhouse | 4 | 2740 | $1,137,000 | 90 | 414.9635037 | Condos listed | |
| 5 | RE-1019 | Downtown | Condo | 5 | 2740 | $1,135,000 | 140 | 414.2335766 | Avg price Riverside | |
| 6 | RE-1002 | Downtown | House | 4 | 2380 | $1,131,000 | 143 | 475.210084 | Highest price | |
| 7 | RE-1049 | Hillcrest | House | 5 | 3000 | $1,130,000 | 133 | 376.6666667 | Neighborhood of highest | |
| 8 | RE-1025 | Lakeside | Townhouse | 5 | 2710 | $1,111,000 | 24 | 409.9630996 | ||
| 9 | RE-1022 | Hillcrest | Condo | 5 | 3130 | $1,080,000 | 123 | 345.0479233 | ||
| 10 | RE-1007 | Downtown | Condo | 5 | 2850 | $1,072,000 | 148 | 376.1403509 | ||
| 11 | RE-1009 | Downtown | Townhouse | 5 | 2580 | $1,030,000 | 7 | 399.2248062 |
Real estate
Real Estate Analysis
10 steps · 3 h
FluentExcel project · Sales
Sales Dashboard
9 steps · 150 rows of data · 172 formulas
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Order | Date | Rep | Region | Product | Units | Unit price | Revenue | Summary | |
| 2 | SO-2001 | 1/2/2026 | Ben | North | Phone | 5 | $599 | 2995 | Total revenue | |
| 3 | SO-2002 | 1/2/2026 | Ana | North | Tablet | 3 | $399 | 1197 | Orders | |
| 4 | SO-2003 | 1/3/2026 | Cara | South | Phone | 5 | $599 | 2995 | Average order | |
| 5 | SO-2004 | 1/4/2026 | Dev | South | Tablet | 2 | $399 | 798 | Top rep | |
| 6 | SO-2005 | 1/4/2026 | Ben | North | Laptop | 3 | $899 | 2697 | ||
| 7 | SO-2006 | 1/8/2026 | Cara | South | Laptop | 1 | $899 | 899 | ||
| 8 | SO-2007 | 1/9/2026 | Cara | South | Monitor | 4 | $229 | 916 | ||
| 9 | SO-2008 | 1/10/2026 | Cara | South | Phone | 1 | $599 | 599 | ||
| 10 | SO-2009 | 1/11/2026 | Eli | East | Headset | 5 | $79 | 395 | ||
| 11 | SO-2010 | 1/13/2026 | Eli | East | Tablet | 2 | $399 | 798 |
Monthly revenue
Sales
Sales Dashboard
9 steps · 3 h