Gathering as much detailed information on the FINPACK balance sheet aids in data transfer throughout the FINPACK software. Annual capital asset transactions are no different. Entering capital asset purchase and sales information on the balance sheet allows for efficient and accurate data transfer to the FINPACK Financial Analysis tools. This includes Schedule F Cash to Accrual, Earned Net Worth Analysis, and the FINPACK Financial Analysis tool (FINAN). Let’s take a closer look at how this works.
Starting with the balance sheet
Entering the details of capital purchases and sales of intermediate and long term assets is the initial step. In the detailed entry for the specific capital asset item, be sure to include the Year Purchased and Purchase Price information for capital assets acquired during the year. This will allow you to transfer capital purchase details to FINPACK’s Financial Analysis tools.
To enter capital sales information in the detailed entry, begin with selecting the “Show sold assets” checkbox. This opens two additional columns of data entry – Year Sold/Traded and Sale Price. The details of the asset sale or trade are entered in these cells. The value of the sold or traded asset is automatically removed from the total owned assets listed.
When “Show sold assets” is not selected, these two columns of data entry are hidden. To print a list of sold items, select “Print sold items by category” in the print dialogue. A list of sold items by capital asset category is then included with the balance sheet output.
Including capital transactions in past performance analysis
The capital asset purchase and sale details entered in the FINPACK balance sheet can be efficiently transferred into the FINPACK Financial Analysis tools, including Schedule F Cash to Accrual, Earned Net Worth Analysis, and Financial Analysis (FINAN). To do so, go into Capital purchases / Capital Sales detailed entry. Place your cursor in the correct capital purchase or capital sale asset category. The example below includes a machinery and equipment capital purchase. When the correct capital asset category is selected, use the “Select from balance sheet items” icon.
Selecting this icon will open a dialogue box with the correct capital purchase or capital sale detail from the balance sheet for the year. Select the appropriate items to be included in the analysis.
Repeat for other capital transactions that need to be included in the analysis. Using this procedure will accurately and efficiently include the capital purchase and capital sale details from the balance sheet into the FINPACK financial analysis tool you are using.
FINPACK continually works to help you gain efficiencies in the credit analysis process. This is one example of FINPACK’s streamlined data flow throughout the software.
Pauline Van Nurden joined the FINPACK Team as an Economist in 2017.
Prior to joining the FINPACK Team, she worked as a lender. This provides her valuable industry experience and knowledge in her work with FINAPCK. Pauline holds a Master’s Degree in Agricultural Education and Bachelor’s Degree in Applied Economics, both from the University of Minnesota.