Category : Lotus and other Spreadsheets
Archive   : FINANCE.ZIP
Filename : LEASEBUY.WK3





























H†Ï"ü†ÏP
,NC 
NC
!

 €ÿ?øÿ@
V


LBLB²







qqq
ÿ€ñ
ÿ€²

ÿ€±



','Lease v/s Buy: Commercial Office Space
\=

\=
\=
\=
\=
\=
\=
\=
\= 'Inputs'|'Analysis\-
\-'|\-'Analysis horizon
'|'Est. Ann Mortgage Pmt..úVC؁„@
 




8'Marginal Tax Rate'|'Cost of Owning?øŽ+N ¾@




;

'|'Cost of Leasing|’@

 'Buy'|\-
'Purchase Price C '| 'Owning Minus Leasing à;®P`8A®@



'Percent Down Payment
%
'|
'Capital Cost of Owning?
$¢ÑÄÎT· @
 




 


'Land Value#'|'Tax Cost of Owning‘€•“¿ÙM¹ç
À





;
 









;9



'Horizon Prop. Appreciation e '| \-

'Mortgage Interest Rate
-
'|
'Raw Cost/(Benefit)
'Mortgage in Years'|' of Owningk)¼3ךÍ@ÿ P
 
'Yearly Prop. Insur./Maint.''|'|'Est. Appreciation|’@
 
 'Lease'|'Depreciation Tax Saving0Š¢(Š¢(jå @
 



'Annual Laease PaymentÃ'|\-
'Annual Investment Rate
'|Mè>° àÿÿAmount Saved By



 Buying Leasing;Amount Saved By Buying$’½`æô²·@


!'|-