Excel | Tag
Here you can find free templates tagged with excel. These templates will hopfully help you to do a faster and better job.
Calculate present value of an annuity loan is a free template to calculate the value or settlement amount for an annuity loan sold in second hand from the previous owner to a new holder.
Process capability is a free template to calculate the capability or the ability for a process to produce within specified tolerance ranges. Process capability is a process ability to meet design specifications.
Calculate reorder point and safety stock is a free template to calculate the safety stock and reorder point for several products depending on demand, standard deviation of demand and delivery time. Reorder point is a decision rule for the purchase of goods with independent demand.
Here you can download free code to calculate the number of used columns and used rows in a worksheet in Excel.
Present value calculation of periodic payments is a free template that can be used to calculate the present value of future payments that are made in equal amounts per period and / or a payment made on one occasion.
Calculate wage for self-employed is a free template to calculate the gross pay and the net pay for a self-employed depending on company profit. As a self-employed you need to calculate the wage to pay to yourself depending on the profit in the business and the taxes.
Capital budgeting with calculations of present value, IRR and profitability index is a free template to decide on an investment based on calculations with the net present value method and the internal interest rate method for one or more investment alternatives.
Here you can download free code that shows you how a collection of objects can be used in VBA code for programming in Excel, when you need to manage data in lists.
Company valuation is a free template to make a valuation of a company and calculate a company value. An enterprise value is based on a company's future ability to generate earnings and cash flows.
Contribution calculation is a free template to establish a product calculus on the principles of contribution calculations. A contribution calculation is a product calculus where incomplete allocation of costs is made to products, only incremental costs are allocated to objects.