Excel 11

mosken_e06ws11_grader_a1.xlsx

BuildingAnalysis

Loan Analysis		Investment Analysis		Asset Information
Purchase Price	$300,000	Initial Investment	RRR	Initial Cost	Salvage Value	Useful Life
Starting Capital	$175,000	($300,000)	18%	$300,000	$125,000	7
		Year	Cash Flows
Amount to Finance		0	($300,000)	Straight-Line Depreciation
APR (Rate)	6.75%	1	$95,000	Year	Yearly Depreciation Expense	Accumulated Depreciation	Book Value
Term (in years)	7	2	$100,000	1
Periods Per Year	4	3	$110,000	2
		4	$75,000	3
Quarterly Payment		5	$55,000	4
Total Cumulative Interest		6	$35,000	5
		7	$25,000	6
Total Cost of Loan		NPV		7
				Declining Balance Depreciation
				Year	Yearly Depreciation Expense	Accumulated Depreciation	Book Value
				1
				2
				3
				4
				5
				6
				7

Create Date	By Whom	Description	Workbook Name
mm/dd/yyyy	Firstname Lastname		e06ws11Building.xlsx
Mod. Date	By Whom	Mod. Description	Last Version Backup Name : VERSION BACKUP NAME : Before modifying any worksheet, save the original workbook with the following name format: Original name_yyyymmdd
Create Date	Sheet Name	Creator	Purpose