Multifamily Expenses_Solution

xlsx

School

University of Florida *

*We aren’t endorsed by this school

Course

6045

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

32

Uploaded by Colonel_World_Turkey15

Report
Inputs Property Overview Name Multifamily Property Type Multifamily Location Boston, MA Units 150 Year Built 2015 Acquisition Assumptions Acquisition Date 12/31/2020 Hold Period Purchase Price Acquisition Closing Costs Drivers In-place Income (T-3) Assumption Total Occupancy 88% Effective Rent / Month $1,220 Net Effective Rent $2,195,977 Vacancy Loss (262,880) Non-Revenue Units 0.7% (15,555) Bad Debt 0.7% (15,848) Total Rental Income $1,901,695
Utility Reimbursement 49,573 Other Income 127,574 Total Income $2,078,842 Revenue & Expense Assumptions Rent Year Occupancy Growth 1 90% 0.0% 2 91% 2.0% 3 92% 3.0% 4 93% 3.0% 5 93% 3.0% 6 93% 3.0% 7 93% 3.0% 8 93% 3.0% 9 93% 3.0% 10 93% 3.0% 11 93% 3.0% Capital Expenditures Schedule Start End Duration Defensive Offensive 3/31/2021 3/31/2022 12 Months Unit Renovations Units Renovated – – Remaining Units 100% 150 Units Renovated / Month 13 Cost / Unit $6,000 Rent Premium $125 ROI 25.0%
In-place Expenses % Per Unit Total Repairs & Maintenance 400 60,000 Turnover 150 22,500 Marketing 150 22,500 General & Administrative 250 37,500 Payroll 600 90,000 Management Fees 3.0% 380 57,051 Utilities 300 45,000 Real Estate Taxes 2,667 400,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Property Insurance 200 30,000 Subtotal $5,097 $764,551 Capital Reserves 200 30,000 Total $5,297 $794,551 Other Revenue Expense RET Growth Growth Growth 0.0% 0.0% 0.0% 3.0% 2.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% 3.0% Unit Mix Type Size Count % of Total Studio 500 15 10.0% 1 BR, 1 BA 750 80 53.3% 2 BR, 2 BA 1,250 50 33.3% 3 BR, 2 BA 1,500 5 3.3% Total 917 150 100%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Model Acq Date 12/31/2020 Size 150 T-3 T-12 Units Unrenovated Units Renovated Unrenovated Effective Rent Renovated Effective Rent Rent Growth INCOME Net Effective Rent 2,195,977 2,167,002 Vacancy Loss (262,880) (259,411) Non-Revenue Units (15,555) (15,349) Bad Debt (15,848) (15,639) Total Rental Income $1,901,695 $1,876,603 Effective Rent / Month $1,220 $1,204 Physical Occupancy 88% 88% Utility Reimbursement 49,573 48,919 Other Revenue 127,574 125,891 Total Other Revenue $177,147 $174,810 TOTAL INCOME $2,078,842 $2,051,413 OPERATING EXPENSES Repairs & Maintenance (64,073) (63,227) Turnover (22,952) (22,649) Marketing (18,312) (18,071) General & Administrative (38,573) (38,064) Payroll (90,273) (89,082) Management Fees (62,365) (61,542) Utilities (44,136) (43,553) Real Estate Taxes (357,792) (353,071) Property Insurance (29,506) (29,116) TOTAL OPERATING EXPENSES ($727,981) ($718,376)
NET OPERATING INCOME $1,350,861 $1,333,037
Year 0 Year 1 Year 1 Year 1 Year 1 Year 1 Month 0 Month 1 Month 2 Month 3 Month 4 Month 5 12/31/2020 1/31/2021 2/28/2021 3/31/2021 4/30/2021 5/31/2021 150 150 150 138 125 113 – – – 13 25 38 $1,220 $1,220 $1,220 $1,220 $1,220 $1,220 $1,345 $1,345 $1,345 $1,345 $1,345 $1,345 – – – – – 182,998 182,998 184,561 186,123 187,686 (18,300) (18,300) (18,456) (18,612) (18,769) (1,296) (1,296) (1,307) (1,318) (1,329) (1,321) (1,321) (1,332) (1,343) (1,354) $162,081 $162,081 $163,465 $164,849 $166,233 $1,220 $1,220 $1,230 $1,241 $1,251 90% 90% 90% 90% 90% 4,131 4,131 4,131 4,131 4,131 10,631 10,631 10,631 10,631 10,631 $14,762 $14,762 $14,762 $14,762 $14,762 $176,844 $176,844 $178,228 $179,611 $180,995 (5,000) (5,000) (5,000) (5,000) (5,000) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (3,125) (3,125) (3,125) (3,125) (3,125) (7,500) (7,500) (7,500) (7,500) (7,500) (4,862) (4,862) (4,904) (4,945) (4,987) (3,750) (3,750) (3,750) (3,750) (3,750) (33,333) (33,333) (33,333) (33,333) (33,333) (2,500) (2,500) (2,500) (2,500) (2,500) ($63,821) ($63,821) ($63,862) ($63,904) ($63,945)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$113,023 $113,023 $114,365 $115,708 $117,050
Year 1 Year 1 Year 1 Year 1 Year 1 Year 1 Year 1 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 6/30/2021 7/31/2021 8/31/2021 9/30/2021 10/31/2021 11/30/2021 12/31/2021 100 88 75 63 50 38 25 50 63 75 88 100 113 125 $1,220 $1,220 $1,220 $1,220 $1,220 $1,220 $1,220 $1,345 $1,345 $1,345 $1,345 $1,345 $1,345 $1,345 – – – – – – – 189,248 190,811 192,373 193,936 195,498 197,061 198,623 (18,925) (19,081) (19,237) (19,394) (19,550) (19,706) (19,862) (1,340) (1,352) (1,363) (1,374) (1,385) (1,396) (1,407) (1,366) (1,377) (1,388) (1,400) (1,411) (1,422) (1,433) $167,617 $169,001 $170,385 $171,769 $173,153 $174,537 $175,920 $1,262 $1,272 $1,282 $1,293 $1,303 $1,314 $1,324 90% 90% 90% 90% 90% 90% 90% 4,131 4,131 4,131 4,131 4,131 4,131 4,131 10,631 10,631 10,631 10,631 10,631 10,631 10,631 $14,762 $14,762 $14,762 $14,762 $14,762 $14,762 $14,762 $182,379 $183,763 $185,147 $186,531 $187,915 $189,299 $190,683 (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (5,000) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (1,875) (3,125) (3,125) (3,125) (3,125) (3,125) (3,125) (3,125) (7,500) (7,500) (7,500) (7,500) (7,500) (7,500) (7,500) (5,029) (5,070) (5,112) (5,153) (5,195) (5,236) (5,278) (3,750) (3,750) (3,750) (3,750) (3,750) (3,750) (3,750) (33,333) (33,333) (33,333) (33,333) (33,333) (33,333) (33,333) (2,500) (2,500) (2,500) (2,500) (2,500) (2,500) (2,500) ($63,987) ($64,028) ($64,070) ($64,111) ($64,153) ($64,194) ($64,236)
$118,392 $119,735 $121,077 $122,420 $123,762 $125,104 $126,447
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Year 2 Year 2 Year 2 Year 2 Year 2 Year 2 Year 2 Month 13 Month 14 Month 15 Month 16 Month 17 Month 18 Month 19 1/31/2022 2/28/2022 3/31/2022 4/30/2022 5/31/2022 6/30/2022 7/31/2022 13 – – – – – – 138 150 150 150 150 150 150 $1,222 $1,224 $1,226 $1,228 $1,230 $1,232 $1,234 $1,347 $1,349 $1,351 $1,353 $1,355 $1,357 $1,359 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 0.2% 200,491 202,359 202,665 202,971 203,278 203,586 203,894 (18,044) (18,212) (18,240) (18,267) (18,295) (18,323) (18,350) (1,420) (1,433) (1,436) (1,438) (1,440) (1,442) (1,444) (1,447) (1,460) (1,463) (1,465) (1,467) (1,469) (1,471) $179,579 $181,253 $181,527 $181,801 $182,076 $182,352 $182,628 $1,337 $1,349 $1,351 $1,353 $1,355 $1,357 $1,359 91% 91% 91% 91% 91% 91% 91% 4,255 4,255 4,255 4,255 4,255 4,255 4,255 10,950 10,950 10,950 10,950 10,950 10,950 10,950 $15,205 $15,205 $15,205 $15,205 $15,205 $15,205 $15,205 $194,785 $196,458 $196,732 $197,006 $197,281 $197,557 $197,833 (5,100) (5,100) (5,100) (5,100) (5,100) (5,100) (5,100) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (3,188) (3,188) (3,188) (3,188) (3,188) (3,188) (3,188) (7,650) (7,650) (7,650) (7,650) (7,650) (7,650) (7,650) (5,387) (5,438) (5,446) (5,454) (5,462) (5,471) (5,479) (3,825) (3,825) (3,825) (3,825) (3,825) (3,825) (3,825) (34,333) (34,333) (34,333) (34,333) (34,333) (34,333) (34,333) (2,550) (2,550) (2,550) (2,550) (2,550) (2,550) (2,550) ($65,858) ($65,908) ($65,917) ($65,925) ($65,933) ($65,941) ($65,950)
$128,926 $130,549 $130,815 $131,082 $131,348 $131,615 $131,883
Year 2 Year 2 Year 2 Year 2 Year 2 Month 20 Month 21 Month 22 Month 23 Month 24 8/31/2022 9/30/2022 10/31/2022 11/30/2022 12/31/2022 – – – – – 150 150 150 150 150 $1,236 $1,238 $1,240 $1,243 $1,245 $1,361 $1,363 $1,365 $1,368 $1,370 0.2% 0.2% 0.2% 0.2% 0.2% 204,202 204,511 204,821 205,131 205,442 (18,378) (18,406) (18,434) (18,462) (18,490) (1,446) (1,449) (1,451) (1,453) (1,455) (1,474) (1,476) (1,478) (1,480) (1,483) $182,904 $183,181 $183,458 $183,736 $184,014 $1,361 $1,363 $1,365 $1,368 $1,370 91% 91% 91% 91% 91% 4,255 4,255 4,255 4,255 4,255 10,950 10,950 10,950 10,950 10,950 $15,205 $15,205 $15,205 $15,205 $15,205 $198,109 $198,386 $198,663 $198,941 $199,219 (5,100) (5,100) (5,100) (5,100) (5,100) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (1,913) (3,188) (3,188) (3,188) (3,188) (3,188) (7,650) (7,650) (7,650) (7,650) (7,650) (5,487) (5,495) (5,504) (5,512) (5,520) (3,825) (3,825) (3,825) (3,825) (3,825) (34,333) (34,333) (34,333) (34,333) (34,333) (2,550) (2,550) (2,550) (2,550) (2,550) ($65,958) ($65,966) ($65,975) ($65,983) ($65,991)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
$132,151 $132,420 $132,689 $132,958 $133,228
Historical Financials Month Ending Month Ending 1/31/2019 2/28/2019 Actual Actual INCOME: RENTAL INCOME: 1 GROSS POTENTIAL 165,880.72 169,266.04 2 LOSS TO VACANCY -19,070.96 -19,460.16 1 LOSS TO LEASE -6,490.96 -6,623.43 1 UPFRONT CONCESSIONS -79.65 -81.27 4 BAD DEBT -1,149.71 -1,173.17 3 MODEL / OFFICE RENT -1,128.43 -1,151.46 4 RECOVERY OF BAD DEBT 0.00 0.00 TOTAL RENTAL INCOME: 137,961.01 140,776.54 OTHER INCOME: 6 LATE FEES 960.03 979.63 6 APPLICATION FEES 312.90 319.29 6 MONTH TO MONTH FEES 279.90 285.62 6 SHORT TERM LEASE FEE 653.96 667.31 6 UTILITY PENALTY FEE 0.00 0.00 6 DEPOSIT FORFEITURE 184.90 188.67 6 ADMIN FEE 519.13 529.72 6 NON REFUNDABLE PET DEP 0.00 0.00 6 NSF CHECK FEES 28.45 29.03 6 PARKING & STORAGE FEES 469.92 479.51 6 CABLE 0.00 0.00 6 RENTERS INSURANCE 0.00 0.00 6 PET FEES 1,213.77 1,238.54 5 PEST CONTROL REIMB 314.52 320.94 6 DAMAGES PAID BY TENANT 530.74 541.58 6 TERMINATION FEES 3,453.46 3,523.94 6 LEGAL & COLLECTION REV 92.45 94.33 6 VACANT COST RECOVERY -0.30 -0.30 5 RUBS - TRASH 1,059.88 1,081.51 5 RUBS - WATER 2,221.96 2,267.30 6 CLEANING FEES 35.56 36.28 6 MISCELLANEOUS INCOME 359.66 367.00 6 INTEREST INCOME 160.50 163.78
TOTAL OTHER INCOME 12,851.38 13,113.65 TOTAL INCOME 150,812.38 153,890.19 PROPERTY EXPENSES: REPAIRS & MAINTENANCE: HVAC 63.83 65.13 PLUMBING 62.71 63.99 CARPET REPAIR 0.00 0.00 ELECTRIC 66.09 67.44 MAINTENANCE SUPPLIES 66.74 68.10 LIGHTING SUPPLIES 171.22 174.72 DOORS & WINDOWS 50.74 51.77 BLINDS & DRAPERIES 0.00 0.00 ELEVATOR SERVICE 641.91 655.01 EXTERMINATION 0.00 0.00 PAINTING - EXTERIOR 0.00 0.00 UNIFORMS 120.60 123.06 GARAGE 0.00 0.00 POOL 143.61 146.54 FIRE PREVENTION 201.39 205.50 CONTRACT CLEANING-COMM 769.02 784.72 RECREATIONAL FACILITIES 122.46 124.96 EQUIPMENT REPAIR/GATES 0.00 0.00 7 TOTAL REPAIRS & MAINTENA 2,480.33 2,530.95 GROUNDS MAINTENANCE: LANDSCAPING 0.00 0.00 LAWN CARE 2,167.90 2,212.14 IRRIGATION REPAIRS 0.00 0.00 SNOW REMOVAL 0.00 0.00 SALT SUPPLY(ICE REMOVAL) 0.00 0.00 7 TOTAL GROUNDS MAINTENAN 2,167.90 2,212.14 APARTMENT TURN COSTS: CARPET CLEANING 246.05 251.07 PAINTING - INTERIOR APT 1,163.42 1,187.16 PAINTING SUPPLIES 98.83 100.85 APPLIANCES - PARTS 15.30 15.61 LOCKS & KEYS 76.49 78.05
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
APARTMENT CLEANING 0.00 0.00 CLEANING SUPPLIES 64.97 66.30 8 TOTAL APARTMENT TURN COS 1,665.07 1,699.05 LEASING COSTS: REFERRAL FEES 0.00 0.00 PROMOTIONAL FEES 423.05 431.69 CREDIT REPORTS 152.45 155.56 ADVERTISING 752.99 768.35 MODEL EXPENSE 0.00 0.00 9 TOTAL LEASING COSTS 1,328.49 1,355.61 GENERAL & ADMINISTRATIVE: COMPUTER & SOFTWARE 1,321.57 1,348.54 TELEPHONE - BASIC 558.99 570.40 TELEPHONE - LONG DIST. 50.39 51.41 ANSWERING SERVICE 26.22 26.76 TRAINING 17.07 17.42 DUES/ SUBSCIPTION 266.68 272.12 TRAVEL 0.00 0.00 MILEAGE REIMBURSEMENT 11.62 11.85 MEALS & ENTERTAINMENT 38.70 39.49 TENANT PARTIES 0.00 0.00 EMPLOYEE BENEFITS/ACTIVIT 0.00 0.00 POSTAGE/COURIER 5.52 5.64 OFFICE SUPPLIES 195.40 199.39 ALARM SYSTEM 54.62 55.73 COPYING EXPENSE 0.00 0.00 LICENSE & PERMITS 0.00 0.00 NEW HIRE EXPENSES 33.13 33.80 BANK CHARGES 33.57 34.25 PAYMENT PROCESSING FEES 0.00 0.00 10 TOTAL GENERAL & ADMINISTR 2,613.46 2,666.80 PROPERTY PAYROLL: MAINTENANCE PAYROLL 2,540.74 2,592.60 MAINTENANCE O/T 79.90 81.53 MAINTENANCE BONUS 51.20 52.25 PAYROLL OFFICE 2,568.87 2,621.30 OFFICE O/T 0.00 0.00
PAYROLL OFFICE BONUS 557.89 569.27 PAYROLL TAXES 475.09 484.79 PAYROLL ADMIN FEES 22.48 22.94 EMPLOYEE RENT 125.67 128.24 HEALTH INS. -COMPANY 0.00 0.00 401K - COMPANY PORTION 0.00 0.00 WORKERS COMPENSATION 127.15 129.75 11 TOTAL PROPERTY PAYROLL 6,549.00 6,682.65 LEGAL & ACCOUNTING: EVICTION/FILING FEES 184.90 188.67 LEGAL EXPENSE 0.00 0.00 10 TOTAL LEGAL & ACCOUNTING 184.90 188.67 MANAGEMENT FEES: MANAGEMENT FEES 4,524.37 4,616.70 12 TOTAL MANAGEMENT FEES 4,524.37 4,616.70 TOTAL PROPERTY EXPENSES 21,513.52 21,952.57 UTILITIES: ELECTRICITY - PUBLIC 1,759.49 1,795.40 ELECTRICITY - TENANT 166.94 170.35 WATER SEWER 1,231.01 1,256.14 UTILITY PROCESSING FEE 0.00 0.00 GAS 44.44 45.34 DISPOSAL SERVICE 0.00 0.00 13 TOTAL UTILITIES 3,201.88 3,267.23 TAXES & INSURANCE: 14 REAL ESTATE TAXES 25,956.46 26,486.19 15 PROPERTY INSURANCE 2,140.52 2,184.20 TOTAL TAXES & INSURANCE 28,096.98 28,670.39 INCOME 1 Net Effective Rent 159,310 162,561 2 Vacancy Loss (19,071) (19,460)
3 Non-Revenue Units (1,128) (1,151) 4 Bad Debt (1,150) (1,173) Total Rental Income $137,961 $140,777 5 Utility Reimbursement 3,596 3,670 6 Other Revenue 9,255 9,444 Total Other Revenue $12,851 $13,114 TOTAL INCOME $150,812 $153,890 OPERATING EXPENSES 7 Repairs & Maintenance 4,648 4,743 8 Turnover 1,665 1,699 9 Marketing 1,328 1,356 10 General & Administrative 2,798 2,855 11 Payroll 6,549 6,683 12 Management Fees 4,524 4,617 13 Utilities 3,202 3,267 14 Real Estate Taxes 25,956 26,486 15 Property Insurance 2,141 2,184 TOTAL OPERATING EXPENSES $52,812 $53,890 NET OPERATING INCOME $98,000 $100,000 Check Ok Ok
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Month Ending Month Ending Month Ending Month Ending Month Ending Month Ending 3/31/2019 4/30/2019 5/31/2019 6/30/2019 7/31/2019 8/31/2019 Actual Actual Actual Actual Actual Actual 174,344.02 181,317.78 190,383.67 199,902.85 197,903.82 201,861.90 -20,043.97 -20,845.73 -21,888.01 -22,982.41 -22,752.59 -23,207.64 -6,822.14 -7,095.02 -7,449.77 -7,822.26 -7,744.04 -7,898.92 -83.71 -87.06 -91.41 -95.98 -95.02 -96.92 -1,208.37 -1,256.70 -1,319.54 -1,385.51 -1,371.66 -1,399.09 -1,186.00 -1,233.44 -1,295.12 -1,359.87 -1,346.27 -1,373.20 0.00 0.00 0.00 0.00 0.00 0.00 144,999.83 150,799.83 158,339.82 166,256.81 164,594.24 167,886.13 1,009.01 1,049.38 1,101.84 1,156.94 1,145.37 1,168.27 328.86 342.02 359.12 377.08 373.30 380.77 294.18 305.95 321.25 337.31 333.94 340.62 687.33 714.82 750.56 788.09 780.21 795.81 0.00 0.00 0.00 0.00 0.00 0.00 194.33 202.10 212.21 222.82 220.59 225.00 545.62 567.44 595.81 625.60 619.35 631.73 0.00 0.00 0.00 0.00 0.00 0.00 29.90 31.09 32.65 34.28 33.94 34.62 493.89 513.65 539.33 566.30 560.64 571.85 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,275.69 1,326.72 1,393.06 1,462.71 1,448.08 1,477.05 330.57 343.79 360.98 379.03 375.24 382.74 557.82 580.14 609.14 639.60 633.20 645.87 3,629.66 3,774.84 3,963.58 4,161.76 4,120.15 4,202.55 97.16 101.05 106.10 111.41 110.29 112.50 -0.31 -0.32 -0.34 -0.36 -0.35 -0.36 1,113.95 1,158.51 1,216.44 1,277.26 1,264.49 1,289.77 2,335.32 2,428.73 2,550.17 2,677.68 2,650.90 2,703.92 37.37 38.87 40.81 42.85 42.42 43.27 378.01 393.13 412.78 433.42 429.09 437.67 168.69 175.44 184.21 193.42 191.49 195.32
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
13,507.06 14,047.34 14,749.71 15,487.19 15,332.32 15,638.97 158,506.89 164,847.17 173,089.53 181,744.00 179,926.56 183,525.09 67.09 69.77 73.26 76.92 76.15 77.67 65.91 68.55 71.97 75.57 74.82 76.31 0.00 0.00 0.00 0.00 0.00 0.00 69.47 72.24 75.86 79.65 78.85 80.43 70.14 72.95 76.60 80.43 79.62 81.21 179.96 187.16 196.51 206.34 204.28 208.36 53.33 55.46 58.23 61.14 60.53 61.74 0.00 0.00 0.00 0.00 0.00 0.00 674.66 701.65 736.73 773.57 765.83 781.15 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 126.75 131.82 138.41 145.34 143.88 146.76 0.00 0.00 0.00 0.00 0.00 0.00 150.94 156.98 164.83 173.07 171.34 174.76 211.67 220.14 231.14 242.70 240.27 245.08 808.26 840.59 882.62 926.75 917.48 935.83 128.71 133.86 140.55 147.58 146.10 149.02 0.00 0.00 0.00 0.00 0.00 0.00 2,606.88 2,711.16 2,846.72 2,989.05 2,959.16 3,018.34 0.00 0.00 0.00 0.00 0.00 0.00 2,278.51 2,369.65 2,488.13 2,612.53 2,586.41 2,638.14 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,278.51 2,369.65 2,488.13 2,612.53 2,586.41 2,638.14 258.61 268.95 282.40 296.52 293.55 299.42 1,222.78 1,271.69 1,335.27 1,402.04 1,388.02 1,415.78 103.87 108.03 113.43 119.10 117.91 120.27 16.08 16.72 17.56 18.44 18.25 18.62 80.40 83.61 87.79 92.18 91.26 93.08
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0.00 0.00 0.00 0.00 0.00 0.00 68.28 71.02 74.57 78.29 77.51 79.06 1,750.02 1,820.02 1,911.02 2,006.57 1,986.50 2,026.23 0.00 0.00 0.00 0.00 0.00 0.00 444.64 462.42 485.55 509.82 504.73 514.82 160.23 166.64 174.97 183.72 181.88 185.52 791.41 823.06 864.21 907.43 898.35 916.32 0.00 0.00 0.00 0.00 0.00 0.00 1,396.27 1,452.12 1,524.73 1,600.97 1,584.96 1,616.66 1,389.00 1,444.56 1,516.78 1,592.62 1,576.70 1,608.23 587.51 611.01 641.56 673.64 666.91 680.24 52.96 55.07 57.83 60.72 60.11 61.31 27.56 28.66 30.09 31.60 31.28 31.91 17.94 18.66 19.59 20.57 20.36 20.77 280.28 291.49 306.07 321.37 318.16 324.52 0.00 0.00 0.00 0.00 0.00 0.00 12.21 12.70 13.33 14.00 13.86 14.14 40.67 42.30 44.42 46.64 46.17 47.09 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 5.81 6.04 6.34 6.66 6.59 6.72 205.37 213.59 224.27 235.48 233.13 237.79 57.40 59.70 62.68 65.82 65.16 66.46 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 34.82 36.21 38.02 39.92 39.52 40.31 35.28 36.69 38.52 40.45 40.05 40.85 0.00 0.00 0.00 0.00 0.00 0.00 2,746.80 2,856.68 2,999.51 3,149.49 3,117.99 3,180.35 2,670.37 2,777.19 2,916.05 3,061.85 3,031.23 3,091.86 83.97 87.33 91.70 96.28 95.32 97.23 53.81 55.97 58.77 61.70 61.09 62.31 2,699.94 2,807.94 2,948.33 3,095.75 3,064.79 3,126.09 0.00 0.00 0.00 0.00 0.00 0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
586.35 609.80 640.29 672.31 665.59 678.90 499.33 519.31 545.27 572.53 566.81 578.15 23.62 24.57 25.80 27.09 26.82 27.35 132.08 137.37 144.24 151.45 149.93 152.93 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 133.64 138.98 145.93 153.23 151.70 154.73 6,883.13 7,158.45 7,516.38 7,892.20 7,813.27 7,969.54 194.33 202.10 212.21 222.82 220.59 225.00 0.00 0.00 0.00 0.00 0.00 0.00 194.33 202.10 212.21 222.82 220.59 225.00 4,755.20 4,945.41 5,192.68 5,452.32 5,397.79 5,505.75 4,755.20 4,945.41 5,192.68 5,452.32 5,397.79 5,505.75 22,611.14 23,515.59 24,691.37 25,925.94 25,666.68 26,180.01 1,849.26 1,923.23 2,019.39 2,120.36 2,099.16 2,141.14 175.46 182.48 191.60 201.18 199.17 203.16 1,293.82 1,345.57 1,412.85 1,483.49 1,468.66 1,498.03 0.00 0.00 0.00 0.00 0.00 0.00 46.70 48.57 51.00 53.55 53.02 54.08 0.00 0.00 0.00 0.00 0.00 0.00 3,365.25 3,499.86 3,674.85 3,858.59 3,820.00 3,896.40 27,280.77 28,372.00 29,790.60 31,280.13 30,967.33 31,586.68 2,249.73 2,339.72 2,456.70 2,579.54 2,553.74 2,604.82 29,530.50 30,711.72 32,247.31 33,859.67 33,521.08 34,191.50 167,438 174,136 182,842 191,985 190,065 193,866 (20,044) (20,846) (21,888) (22,982) (22,753) (23,208)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(1,186) (1,233) (1,295) (1,360) (1,346) (1,373) (1,208) (1,257) (1,320) (1,386) (1,372) (1,399) $145,000 $150,800 $158,340 $166,257 $164,594 $167,886 3,780 3,931 4,128 4,334 4,291 4,376 9,727 10,116 10,622 11,153 11,042 11,263 $13,507 $14,047 $14,750 $15,487 $15,332 $15,639 $158,507 $164,847 $173,090 $181,744 $179,927 $183,525 4,885 5,081 5,335 5,602 5,546 5,656 1,750 1,820 1,911 2,007 1,987 2,026 1,396 1,452 1,525 1,601 1,585 1,617 2,941 3,059 3,212 3,372 3,339 3,405 6,883 7,158 7,516 7,892 7,813 7,970 4,755 4,945 5,193 5,452 5,398 5,506 3,365 3,500 3,675 3,859 3,820 3,896 27,281 28,372 29,791 31,280 30,967 31,587 2,250 2,340 2,457 2,580 2,554 2,605 $55,507 $57,727 $60,614 $63,644 $63,008 $64,268 $103,000 $107,120 $112,476 $118,100 $116,919 $119,257 Ok Ok Ok Ok Ok Ok
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Month Ending Month Ending Month Ending Month Ending 9/30/2019 10/31/2019 11/30/2019 12/31/2019 Actual Actual Actual Actual 203,880.52 197,764.10 187,875.90 185,997.14 -23,439.72 -22,736.53 -21,599.70 -21,383.70 -7,977.91 -7,738.57 -7,351.64 -7,278.13 -97.89 -94.96 -90.21 -89.31 -1,413.08 -1,370.69 -1,302.15 -1,289.13 -1,386.93 -1,345.32 -1,278.06 -1,265.28 0.00 0.00 0.00 0.00 169,564.99 164,478.04 156,254.14 154,691.59 1,179.96 1,144.56 1,087.33 1,076.46 384.58 373.04 354.39 350.85 344.02 333.70 317.02 313.85 803.77 779.66 740.67 733.27 0.00 0.00 0.00 0.00 227.25 220.43 209.41 207.32 638.05 618.91 587.96 582.08 0.00 0.00 0.00 0.00 34.96 33.91 32.22 31.90 577.57 560.24 532.23 526.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,491.82 1,447.06 1,374.71 1,360.96 386.57 374.97 356.23 352.66 652.33 632.76 601.12 595.11 4,244.57 4,117.24 3,911.37 3,872.26 113.63 110.22 104.71 103.66 -0.36 -0.35 -0.34 -0.33 1,302.67 1,263.59 1,200.41 1,188.41 2,730.96 2,649.03 2,516.58 2,491.41 43.70 42.39 40.27 39.87 442.05 428.78 407.34 403.27 197.27 191.35 181.79 179.97
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
15,795.36 15,321.50 14,555.42 14,409.87 185,360.34 179,799.53 170,809.56 169,101.46 78.45 76.10 72.29 71.57 77.08 74.76 71.03 70.32 0.00 0.00 0.00 0.00 81.23 78.80 74.86 74.11 82.03 79.57 75.59 74.83 210.44 204.13 193.93 191.99 62.36 60.49 57.47 56.89 0.00 0.00 0.00 0.00 788.96 765.29 727.03 719.76 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 148.23 143.78 136.59 135.23 0.00 0.00 0.00 0.00 176.51 171.22 162.65 161.03 247.53 240.10 228.10 225.82 945.19 916.83 870.99 862.28 150.51 146.00 138.70 137.31 0.00 0.00 0.00 0.00 3,048.53 2,957.07 2,809.22 2,781.13 0.00 0.00 0.00 0.00 2,664.52 2,584.58 2,455.35 2,430.80 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 2,664.52 2,584.58 2,455.35 2,430.80 302.42 293.35 278.68 275.89 1,429.93 1,387.04 1,317.68 1,304.51 121.47 117.83 111.94 110.82 18.81 18.24 17.33 17.16 94.02 91.20 86.64 85.77
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
0.00 0.00 0.00 0.00 79.85 77.46 73.58 72.85 2,046.50 1,985.10 1,885.85 1,866.99 0.00 0.00 0.00 0.00 519.97 504.37 479.15 474.36 187.37 181.75 172.66 170.94 925.48 897.72 852.83 844.30 0.00 0.00 0.00 0.00 1,632.82 1,583.84 1,504.65 1,489.60 1,624.31 1,575.58 1,496.80 1,481.84 687.05 666.43 633.11 626.78 61.93 60.07 57.07 56.50 32.23 31.26 29.70 29.40 20.98 20.35 19.33 19.14 327.77 317.93 302.04 299.02 0.00 0.00 0.00 0.00 14.28 13.85 13.16 13.03 47.57 46.14 43.83 43.39 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 6.79 6.59 6.26 6.19 240.17 232.96 221.31 219.10 67.13 65.11 61.86 61.24 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 40.72 39.49 37.52 37.14 41.25 40.02 38.02 37.64 0.00 0.00 0.00 0.00 3,212.15 3,115.79 2,960.00 2,930.40 3,122.78 3,029.09 2,877.64 2,848.86 98.20 95.25 90.49 89.59 62.93 61.04 57.99 57.41 3,157.35 3,062.63 2,909.50 2,880.40 0.00 0.00 0.00 0.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
685.69 665.12 631.86 625.54 583.93 566.41 538.09 532.71 27.63 26.80 25.46 25.20 154.46 149.83 142.34 140.91 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 156.28 151.59 144.01 142.57 8,049.23 7,807.76 7,417.37 7,343.20 227.25 220.43 209.41 207.32 0.00 0.00 0.00 0.00 227.25 220.43 209.41 207.32 5,560.81 5,393.98 5,124.28 5,073.04 5,560.81 5,393.98 5,124.28 5,073.04 26,441.81 25,648.56 24,366.13 24,122.47 2,162.55 2,097.68 1,992.79 1,972.86 205.19 199.03 189.08 187.19 1,513.01 1,467.62 1,394.24 1,380.30 0.00 0.00 0.00 0.00 54.62 52.98 50.33 49.83 0.00 0.00 0.00 0.00 3,935.37 3,817.31 3,626.44 3,590.18 31,902.55 30,945.47 29,398.20 29,104.21 2,630.87 2,551.94 2,424.34 2,400.10 34,533.41 33,497.41 31,822.54 31,504.32 195,805 189,931 180,434 178,630 (23,440) (22,737) (21,600) (21,384)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
(1,387) (1,345) (1,278) (1,265) (1,413) (1,371) (1,302) (1,289) $169,565 $164,478 $156,254 $154,692 4,420 4,288 4,073 4,032 11,375 11,034 10,482 10,377 $15,795 $15,321 $14,555 $14,410 $185,360 $179,800 $170,810 $169,101 5,713 5,542 5,265 5,212 2,046 1,985 1,886 1,867 1,633 1,584 1,505 1,490 3,439 3,336 3,169 3,138 8,049 7,808 7,417 7,343 5,561 5,394 5,124 5,073 3,935 3,817 3,626 3,590 31,903 30,945 29,398 29,104 2,631 2,552 2,424 2,400 $64,911 $62,963 $59,815 $59,217 $120,450 $116,836 $110,994 $109,885 Ok Ok Ok Ok
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

Integrated Project - Part 2 Capital Structure with comments Revised v2-2 (1).docx
Integrated Project Part 4 - Dividend Policy (1).xlsx
Integrated Project Part 4 - Dividend Policy (1).docx
Integrated Project Part 1.docx
Integrated Project Part 2 Capital Structure.xlsx
FRM L2 Mock Exam (1) Questions.pdf
Assignment 3 ACCT 73120 FAll 2023 with solutions.docx
mortgage IO and PO computer assignment - HW.doc
module 9 discussion.docx
Math 123 LA Online Retirement Fund_AC.docx
ACC 201 Project Summary Report Lindsay Thomas.docx
AjayBowalWildcatCase.xlsx
Related Questions
A fixed asset with a cost of $26,000 and accumulated depreciation of $23,400 is sold for $4,420. What is the amount of the gain or loss on the sale of the fixed asset? Oa. $2,600 loss Ob. $2,600 gain Oc. $1.820 loss Od. $1,820 gain Previous Next 7:04 PM 12/11/2020 18 a
d = ces Problem 6-22A (Algo) Accounting for acquisition of assets, including a basket purchase LO 6-1 Trinkle Company made several purchases of long-term assets during the year. The details of each purchase are presented here. New Office Equipment 1. List price: $41,100; terms: 2/10, n/30; paid within the discount period. 2. Transportation-In: $740. 3. Installation: $470. 4. Cost to repair damage during unloading: $624. 5. Routine maintenance cost after eight months: $150. Basket Purchase of Copler, Computer, and Scanner for $53,500 with Fair Market Values 1. Copier, $26,445. 2. Computer, $9,030. 3. Scanner, $29,025. Land for New Warehouse with an Old Building Torn Down 1. Purchase price, $82,400. 2. Demolition of building, $5,410. 3. Lumber sold from old building, $2,210. 4. Grading in preparation for new building, $9,500. 5. Construction of new building, $217,000. Required In each of these cases, determine the amount of cost to be capitalized in the asset accounts. Asset Office…
NCF practice a) What is the ncf from the sale of this asset - purchased for $250,000, 7-year property, sold at end of year 6 for $50,000, tax rate = 21%? basis  = MACRS depreciation (as decimal) * sale price step 1: sales price - basis = gain/loss step 2: gain * loss tax rate = tax step 3: sales price - tax = ncf
In January 1, 2020, the following assets of Company A had the following corresponding values: Carrying amount EUL Sound Value Year acquired 5,400,000 5,750,000 *7.600.000 7,850,000 Machinery Equipment O 3.122.600 O 3.050.000 Ⓒ 2.988.000 Residual Value 3.837.500 500,000 400,000 10 12 The company decided to measure these properties using revaluation model. Full year depreciation is taken on the year of purchase. In January 1, 2022, the replacement cost of equipment was revalued at P5.100.000. What is the amount taken to profit or loss as a result of the revaluation on January 1. 2022? 2017 2016
1. What is the cost of the right of use asset? 2. What is the depreciation for current year?
Requirements: HOW MUCH IS THE REVALUATION SURPLUS ON THE YEAR OF REVALUATION? HOW MUCH IS THE GAIN OR LOSS IF THE BLDG IS SOLD FOR P8MILLION ONE YEAR AFTER REVALUATION? HOW MUCH IS THE BLANCE OF REVALUATION SURPLUS AFTER THE SALE?
Calculate the asset efficiency - receivables, inventory, fixed asset and total asset turnover ratios
Investment PropertyDEF Company owns land and building being used for its operations and administrative functions. The land and building are carried in its books using the cost model and have the following data at January 1,2023.Land:Cost - P10,000,000Fair value - 14,000,000Building:Cost -P20,000,000Accumulated depreciation -13,500,000Fair value - 9,000,000On this date, the company vacated the old building and occupied a newly constructed one located in the commercial area of the Central Business District. The old building is then reclassified as investment property using the fair value model. The company uses the fair value model in all of its other investment property.What is the amount of fair value gain reported in profit/loss resulting from the reclassification from owner occupied to investments property due to change in use of the property?     a. P0 b. P2,500,000 c. P4,000,000 d. P6,500,000
- Entity A acquires equipment on January 1, 20x1. Information on costs is as follows: Purchase price, gross of Php 10,000 trade discount Non-refundable purchase taxes Delivery and handling costs Installation costs 800,000 20,000 40,000 30,000 Present value of decommissioning and restoration Costs 10,000 How much is the initial cost of the equipment? a. 900,000 b. 820,000 c. 870,000 d. 890,000
The total dollar amount of assets to be classified as investment is ?
Please step-by-step answer, please don't use Al solution
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:9781285595047
Author:Weil
Publisher:Cengage
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Text book image
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Text book image
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Text book image
SWFT Comprehensive Volume 2019
Accounting
ISBN:9780357233306
Author:Maloney
Publisher:Cengage
SEE MORE TEXTBOOKS
Related Questions
Recommended textbooks for you
Text book image
Financial Accounting Intro Concepts Meth/Uses
Finance
ISBN:9781285595047
Author:Weil
Publisher:Cengage
Text book image
Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Text book image
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Text book image
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Text book image
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning
Text book image
SWFT Comprehensive Volume 2019
Accounting
ISBN:9780357233306
Author:Maloney
Publisher:Cengage
SEE MORE TEXTBOOKS