How to Make a Finance Spreadsheet

Method 1 of 3:

Create the Check Register

Format the column headings. Type "Transaction date" into cell B19, "Description" in cell C19, "Purchase" in cell D19, "Deposit" in cell E19 and "Balance" in cell H19. Then select cells B19 through H19, and click the word wrap button on the formatting tool bar.
Enter the register formula. Type the following formula into cell H20: =SUM($E$4)-SUM($D$4). Position the mouse pointer in the lower right corner of cellH20 and use the Fill handle (+) to copy the formula from H20 down through H44.
Set the numerical formatting. Select cells D20 through D44, and click the currency ($) option from the number formatting menu. Do the same for cells H20 through H44. The check register balance will automatically update with each new entry.

Method 2 of 3:

Create the Loan Calculator

Enter the column headings. Type "Loan Amount" in cell B1, "Interest Rate" in cell C1, "Term of loan" in cell D1 and "Payment" in cell E1.
Set the numerical formatting. Click in cell B2, and select the currency ($) option from the number formatting menu located on the formatting toolbar. Any value entered in cell B2 will now appear as a dollar amount.
1. Click in cell C2 and select the percentage (%) option from the number formatting menu on the toolbar. Any value entered in cell C2 will now appear as a percentage.
Format the borders. Click in cell B1, and drag to select cells B1 through E2. On the formatting toolbar, click the arrow on the Borders button and select "All borders" from the available options.
Enter the formula in the monthly payment field. Click in cell E2 and enter the following formula: =PMT(c2/12,d2*12,-b2) and press enter. Now select the currency ($) option from the number formatting menu located on the formatting toolbar. The amount of the monthly payment will now appear in cell E2 and will be represented as a dollar amount.

Method 3 of 3:

Create the Loan Payoff Schedule

Enter the column headings for the payoff schedule. Type "Payment Date" in cell A4, "Starting Balance" in cell B4, "Interest paid" in cell C4, "Principal Paid" in cell D4 and "Ending Balance" in cell E4. Select cells A4 through E4 and click the Word wrap button on the formatting tool bar.
Enter the payment dates. Click in cell A5 and enter the date of the first payment. Position the mouse pointer in the lower right corner of cell A5. The Fill handle (+) should now be visible. Click and drag the fill handle from cell A5 to cell A17. The payment dates for the next 12 months should be visible in the payment date column.
Enter the formulas into the corresponding columns of the payoff sheet.
1. Click in cell B5 and type "=B2" under the Starting Balance heading.
2. Click in cell C5 and type "=B5*$C$2/12."
3. Click in cell D5 and type "=$E$2-C5."
4. Click in cell E5 and type "=B5-D5."
5. Click inside cell B6 and type "=E5."
6. Click in cell E6 and type "=B6-D6."
Copy the formulas down each column. Finally, position the mouse pointer in the lower right corner of cell B6 and use the Fill handle (+) to copy the formula from B6 through B17. Repeat this process for cells C6, D6 and E6. The payoff sheet formulas have been entered and the finance spread sheet is ready to use.

Micah Soto

Update 05 March 2020

You should read it

May be interested

Complete guide to Excel 2016 (Part 9): Working with multiple spreadsheets
excel workbook file is a collection of spreadsheet types (can contain from 1 to 255 spreadsheets) such as: data, graphs, macro, . and often related to each other.
How to Make Payroll on Excel in the US
today's tipsmake will guide you how to calculate payroll for employees in the us on microsoft excel. creating a payroll spreadsheet from scratch is an extremely tiring process, but luckily microsoft has a payroll spreadsheet template for excel on both windows and mac computers.
How to send email from Excel spreadsheet with VBA script
sending emails from microsoft excel requires only a few simple scripts. add this function to a spreadsheet and you can really make the most of all features in excel.
How to Learn Spreadsheet Basics with OpenOffice Calc
the term spreadsheet was derived from a large piece of paper that accountants used for business finances. the accountant would spread information like costs, payments, taxes, income, etc out on a single, big, oversized sheet of paper to...
The best budgeting apps in 2020
need to get your spending on track but not sure where to start? check out the best budgeting apps to find the right one for you.
10 tips and tricks in Google Spreadsheet
in this article, i will show you 10 interesting tips and tricks in google spreadsheet and you will be surprised about them
Instructions for inserting a PDF file into Excel spreadsheet
if you're having trouble inserting a pdf file into an excel spreadsheet and you don't know how to do it. inserting pdf files into excel spreadsheets is not as simple as you think. in the article below, network administrator will guide you through the steps to insert a pdf file into excel spreadsheet.
How to Create a Pink Love Note of Spheres in Form of a Heart
want to make art with your math?! here is how to make the image below, which should speak for itself. this spreadsheet involves many new tricks, however, so you may want to learn it for that reason. you do not need to know exactly how...
How to save on your monthly internet bill
are you paying too much for internet service? use these tips to lower your monthly bill.
Guide to full Excel 2016 (Part 7): Format spreadsheet data
if you have seen the article about microsoft word, then you also have some basic knowledge about text alignment. please refer to the article of formatting spreadsheet data in excel 2016 in this article!

How to Make a Finance Spreadsheet

Create the Check Register

Create the Loan Calculator

Create the Loan Payoff Schedule

You should read it

May be interested

Office information