Question: 73% v E A View Zoom Add Category Insert Table Graph Text Shape Media Comment Collaborate Format Organise + CF_Analysis CF_Analysis Pessimistic CF_Analysis Optimistic Amortization_monthly

73% v E A View Zoom Add Category Insert Table Graph Text Shape Media Comment Collaborate Format Organise + CF_Analysis CF_Analysis Pessimistic CF_Analysis Optimistic Amortization_monthly Sheet Sheet Name INPUT TABLE Purchase price 1 100,000 Equity 550.060 CF_Analysis Base annual rent Dulux 55,774 Total initial rent Dulux 4,140.10 Rent review period Dulux 3 years Base Annual rent Sew on Track $17,500.00 Total initial rent Sew on Track $20,125.OL Rent review p 3 Years Background O Total rent all tenancies 34,265.10 Rental increase 3% GST Increase in property value pa 169% Contingencies Purchasing expenses 214,004 12,330 Duplicate Sheet Rates Body Corporate Base OPEX 28 2 OPEX incre 2% Delete Sheet Interest rate 4.69% Capitalisation rate 0.999 Tax rate 0.28 Discount rate Depreciation rat 9% Purchase price less the salavage price divided by the useful years of life the asset has Using RV the structure is 50.35% of the value Mortgage term 30 Holding period 10 years 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 Year NOI Gross income 4265.10 84868.85 86793.05 6793.05 87414.92 1685.30 89396.84 89396.84 90037.36 92078.75 92078.75 Contingencies 1697.38 1735.86 1735.86 1748.30 1787.94 1787.94 1800.75 1841.57 1841.57 Effective gross income 2579.80 83171.47 35057.19 85057.19 85666.62 87608.91 87608.91 88236.62 90237.17 90237.17 OPEX 57659.47 58812.66 59988.92 61188.69 62412.47 63660.72 64933.93 66232.61 67557.26 68908.43 Purchasing expenses 14000.00 Net Operating Income 0920.33 24358.81 25068.28 23868.50 23254.15 23948.19 22674.98 22004.01 22679.91 21328.77 Amortization Mortgage payment 34190.44 34190.44 34190.44 25201.08 24770.30 34190.44 34190.44 34190.44 34190.44 34190.44 3 34190.44 interest payment 5612.16 24318.87 23845.81 23350.08 22830.60 2286.22 21715.75 21117.94 Principal payment 8989.36 9420.14 9871.57 10344.63 10840.36 11359.84 11904.22 12474.69 13072.49 Loan balance 41421.72 532432.37 523012.22 513140.66 502796.03 491955.67 480595.83 468691.61 456216.92 443144.43 Sale Purchase price 1100000.00 Equity $50000.00 Mortgage finance 550000.00 Estimated value 1100000.00 1183600.00 1273553.60 1370343.67 1474489.79 1586551.02 1707128.89 1836870.69 1976472.86 2126684.80 2288312.85 Assumption Sale price 2288312.85 g expense 183065.03 Loan balance 443144.43 Net sale proceedings 662103.39 Before tax cash flows Net Operating Income 10920.33 24358.81 25068.28 23868.50 23254.15 23948.19 22674.98 22004.01 22679.91 21328.77 ( BTCF ) Mortgage payment 34190.44 34190.44 34190.44 34190.44 34190.44 34190.44 34190.44 34190.44 34190.44 34190.44 Net sale proceedings 1662103.39 Before Tax Cash Flow -550000.00 -23270.11 -9831.63 -9122.16 -10321.94 -10936.29 -10242.25 -11515.46 -12186.43 -11510.52 1649241.72 Taxes Net Operating Income 0920.33 24358.81 25068.28 23868.50 23254.15 23948.19 22674.98 22004.01 22679.91 21328.77 Interest pa 25612.16 25201.08 24770.30 23845.81 23350.08 22830.60 22286.22 21715.75 21117.94 Depreciation 11000.00 11000.00 11000.00 11000.00 11000.00 -11842.27 10702.02 11000.00 11000.00 11000.00 11000.00 11000.00 axable income 25691.84 11450.37 11591.66 -10401.89 - 11282.21 -10035.84 -10789.18 ax amount -7193.71 -3315.83 2996.57 -3206.10 -3245.66 -2912.53 -3123.5 3159.02 -2810.03 -3020.97 After tax tax flows Before Tax Cash Flow 550000.00 -23270.11 -9831.63 -9122.16 10321.94 -10936.29 -10242.25 -11515.46 12186.43 -11510.52 1649241.72 (ATCF) ax -7193.71 -3315.83 -2996.57 -3206.10 -3245.66 -2912.53 -3123.57 -3159.02 -2810.03 -3020.97 After Tax Cash Flow -550000.00 -16076.40 -6515.79 -6125.60 -7115.84 -7690.62 -7329.72 -8391.89 -9027.41 -8700.49 1652262.69 NPV $501,998.75 IRR 11%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

due tonight need help. Answer what's in blue, I put those numbers in red but think they are incorrect. thank you This is all the info the teacher gave us. question: 125% T View Zoom Add Category...

How do I figure out the colored formulas and the blank spots? 125% F V View Zoom Add Category Insert Table Chart Text Shape Media Comment Collaborate Format Organize MASTER MASTER Student Name =>...

Use thedata set provided (attached some pictures) and collect a sample consisting of one income level (column). Plan and describe the sampling plan, execute the sampling procedure, then use the...

AutoSave OFF AH ? C ... HW1 template.xIs - Compatibility Mode Home Insert Draw Page Layout Formulas Data Review View Automate ? Tell me Comments Share B7 X V fx B C D E F G H J K L M N O P Q R S T U...

Please complete the following financial statements based on the information given. 125% T Format Organize Add Category Insert Table Chart Text Shape Media Comment Collaborate View Zoom + Genl Journal...

E3 A 125% Format Organize Insert Table Chart Text Shape Media Comment Collaborate Pivot Table View Zoom Add Category Sheet + Lookup Dataset Performance Data Questions Sheet Name Lookup Dataset...

View 125% Zoom 4 Add Page 1 Step 1 6 8 2 3 4 Insert E Table Chart Text Shape Media Comment Instructions Start Excel. Download and open the file named Excel Chp5-6Practice Test.xlsx, Grader has...

Instructions Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. An asterisk (*) will appear to the right of an incorrect...

NOTE: USE $2,500 AS ENDING INTRA-COMPANY INVENTORY IN THE BOOK IN CHAPTER 5, THERE IS A COMPREHENSIVE EXAMPLE FOR A CONSOLIDATED FINANCIAL STATEMENTS FOR A DOWNSTREAM SALE LESSON 5-2/5-3 Part 1 :...

Task Summary As mentioned above, you have to first choose a dataset from Kaggle or other similar websites recommended by your learning facilitator (e.g. Heart Disease UCI}. As the only limitation,...

Internal users include creditors, shareholders, internal auditors and managers. True/ False

Assume the M&M model with corporate taxes and financial distress holds and that the CAPM is true. Protec Corporations Inc. (PCI) is a corporation financed with debt (B) and equity (S). $10 million of...

sasi ltd is registered for vat during the month of November 2024 the company made the following transactions Nov 1 ; sold goods on credit to furaha traders for sh 100000 Nov 4 ;purchased goods on...

Birtle Corporation reports the following statement of financial position information for 2014 and 2015. Prepare the 2014 and 2015 common-size statement of financial position for Birtle. (Round the...