TIMEPLATFORM

BUSINESS / FINANCE DROIDS

Sample Applications: Interest Rate; Flexible Budget / Variance Analysis; Break-Even Analysis; NPV Planning and Sensitvity Analysis; Loan /Lease Analysis


 
 Order Here  2015H2

Business/Finance Droids
All software droids are goal oriented. They all work the same way. You input data in the light Green Cells then press F9 -- all associated outputs are calculated/graphed automatically.
For many applications, tables can be easily expanded to accommodate more input data.
  
Interest Rate Calculators

 
 Equivalent Nominal Interest Rate
   Effective Annual Interest Rate
   Effective Interest Rate Per Payment Period
  
  
Flexible Budget / Variance Analysis

   Flexible Budget
Budgeted Variable, Fixed, Mixed Costs by Cost Category/Cost Item – Actual Costs – Gross Income – Net Operating Income – Break-Even
   Flexible Budget Variance
 
Break-Even Analysis

   Muliproduct/Composite Product Break-Even Analysis
Multiproduct Sales – Composite Product – Weighted Unit Prices and Variable Costs – Break-Even Quantity – Break-Even Gross Income
   Cost-Volume-Profit (CVP)
Break-Even/Degrees of Operating, Financial, and Total Leverage
   CVP Risk Analysis
Probability of Not Achieving Break-Even Quantity and Probability of Exceedong Break-Even Quantity
 
Net Present Value (NPV) Planning and Sensitivity Analysis for Commercial / Industrial Projects
 
   Capital Investment Under Uncertainty
Net Present Worth/Expected ROR
   NPV After Tax vs. Quantity Produced
   Sensitvity of NPV vs. Quantity Produced
Sensitivity to R&D Costs, Initial Cost of Production Facilities, First Unit Cost, Learning Coefficient, Production Rate, Unit Price, Tax Rate, and Cost-of-Capital Rate
   Sensitivity of Break-even Quantity and Maximum Financial Exposure
Sensitivity to R&D Costs, Initial Cost of Production Facilities, First Unit Cost, Learning Coefficient, Production Rate, Unit Price, Tax Rate, and Cost-of-Capital Rate
 
Loan / Lease: Analytics, Sensitivity, Solvers, Amortization Schedules, Accelerated Payments

Impact of Asset Purchase Price, Residual Value or Balloon, Annual Interest Rate, Total Number of Payment Periods, Number of Advance Payments, Frequency of Payments, and When Recurring Payments Are Due on Recurring Payment, Total Interest, and Total Payments
 
Loan/Lease Schedules: Basic/General, Interest Only, Balloon/Resudual Value, Down or Advance Payments, Accelerated (Extra Payments)

Frequency of Payments: D=Daily, W=Weekly, BW=Bi-Weekly, SM=Semi-Monthly, M=Monthly, BM=Bi-Monthly, Q=Quarterly, H=Semi-Yearly, Y=Yearly


   Basic Loan/Lease Analytics
[1] [2]
 
   Loan/Lease Sensitivity
[1] [2]
 
   Loan/Lease Solvers
[1] [2]
 
   Loan Amortization Schedule
[1] [1a] [2] [2a] [2b] [2c] [2d]
 
   Lease Amortization Schedule
[1] [2] [2a]
 
 


Copyright (c) 2014-2015 by Dr. Edward E. Ayoub. All Rights Reserved.
Copyright (c) 2014-2015 by Macroknow Inc. All Rights Reserved.