Docstoc is a user community for sharing documents. Find free documents and upload your docs for all to share.
Finance Lease Use BusinessFunctions/CalculateFull to recalc Base 12 months This is the GoalSeek Cell: (0.0000) StartProj 3 Jan 05 Monday From Tax Date Rate DayCount 6.11 Main Perio... ... more>>
Depreciation Schedule Base 12 months DayCount 3 Actual Days/365. Periods +12.00 in advance, monthly (first day of month) No Business Days: no days excluded * Depreciation Type 0 Straight Line ... more>>
NPV Capitalisation at end of cash flow Review Behaviour Relets PV Date 1 Jan 07 Cap Date 1 Jan 47 Discount To Mkt 10.00% Void 12 months Example of a Business Plan for a Building versus Proposed Deals ... more>>
DCF Analysis Dates Cash Flows Net Present Value 1 Jan 05 (300) 1 Jan 06 (100) NPV Date 1 Jan 06 100 Discount Rate AER * 1 Jan 06 67 How time differences are to be measured: 1 Jan 0... ... more>>
Depreciation Std, Pro Editions Uses DpM, DepreciatedValue, Depreciate Initial Value 100 Initial Date 1 Jan 02 Example 1: Straight Line Example 2: Declining Balance Example 3: Decli... ... more>>
Occupancy Cost Comparison Units: 1,000 Nominal Costs Over Time Net Present value Total Nominal Savings 58,524 Total NPV of Savings 2,224 Now Proposed Savings Location: Where the Te... ... more>>
Construction Loan Techniques Demonstrated: S-curves, re-budgeting, combining timebases, loan with interest roll-up. Requires BF 1.25+ Cost Disbursement Loan fees Loan Interest Rate... ... more>>
Stepped Rents Rent From Rental Payment Setup ??30.00 /sf 15 Feb 07 Periods 13 Eng Qtr Days ??40.00 /sf 1 Aug 07 DayCount 6 ??50.00 /sf 1 Aug 08 Actual/Actual (Within Period). 1 Jan... ... more>>
Frontline Banking plc Timebase Setup Relets Start 1 Jan 07 NIA 200,000 sf Void Periods 1 pa advance Rent Start 1 Apr 07 RentFree Cash/Acc 1 cash Expiry 1 Apr 17 Term Abs Finish 1 J... ... more>>
Week Number Calculator (including ISO) ISO Alternative Example Basis or Date Find a Week Number Given a Date: Date 28 Oct 02 28 Oct 02 Start of Each Week 2 2 Monday Monday Start of... ... more>>
Accounts Receivable Months To Pay 2.00 months Jan-2003 Feb-2003 Mar-2003 Apr-2003 May-2003 Total Sales 100 120 140 160 180 % on Credit 20% 20% 20% 20% 20% Credit Deferrals (20) (24... ... more>>
Standard Bullet Chart To use: 1 Copy the tan (orange) shaded area below including the bullet graph by going Ctrl-C. 2 Go to a blank area in your workbook. Go Ctrl-V. 3 Right-click ... ... more>>