Friday, March 20, 2015

Example of Home Selling Profit Calculation


PURCHASE

Year house bought: 2005
House buying price: $ 500,000
Downpayment (20%): $ 100,000
Mortgage amount: $ 400, 000
Mortgage term: 30 years



SELL
Year home sold (10 years after purchase): 2015
Home selling price: $600,000
Total mortgage payments to the Principal after 10 years: $ 60,000 
Market value increase: $600,000 - $500,000 = $ 100,000



EQUITY


Equity Quick Calculation:

Total Equity = Down Payment + Market Value Increase + Mortgage Payments
Total Equity = $ 100,000  +  $ 100,000  +  $ 60,000
Total Equity = $ 260,000



SELLING COSTS


Breakdown of the Total Cost of Selling Home (8%):
 a. Sales commissions (6%): $ 36,000
 b. Title and escrow fees (1.5%): $ 9,000
 c. Property marketing preparation costs (0.5%): $ 3,000
 d. Renovation costs: $ 12,000

Total Cost of Selling Home = $ 36,000  +  $ 9,000  +  $ 3,000  +  $ 12,000

Total Cost of Selling Home = $ 60,000



NET PROFIT


Total Profit Calculation:

Total Profit = Market Value Increase - Total Cost of Selling Home

Total Profit = $ 100,000  -  $ 60,000

Total Profit = $ 40,000



YEARLY PROFIT


Yearly Profit = Total Profit / 10 years

Yearly Profit = $ 40,000 / 10

Yearly Profit = $ 4,000



MONTHLY PROFIT


Monthly Profit = Yearly Profit / 12

Monthly Profit = $ 4,000 / 12

Monthly Profit = $ 333



--------------------------------------------------------------------------



RENTING for 10 YEARS & SAVING $2000 per month


Yearly Savings = $ 2,000 x 12

Yearly Savings = $ 24,000

Total Savings for 10 years = $ 24,000 x 10

Total Savings for 10 years = $ 240,000



COMPARISON: BUYING HOUSE or RENTING & SAVING


In order to match the $ 240,000 total savings on renting for 10 years,
the market value of the house after 10 years must be 60% greater than the original purchase price.

Calculation Proving:

60% Market value increase after 10 years:


Market value = $ 500,000  x  1.6

Market value = $ 800,000


Market value increase:


Market value increase = $ 800,000  -  $ 500,000

Market value increase = $ 300,000


Net Profit:

Total Profit Calculation:

Total Profit = Market Value Increase - Total Cost of Selling Home

Total Profit = $ 300,000  -  $ 60,000

Total Profit = $ 240,000


Return on Investment (ROI):


ROI = Total Profit / Original Price

ROI = $ 240,000 / $ 500,000

ROI = 48 %


Conclusion:

In order to match the $ 240,000 total savings on renting for 10 years,
the ROI on buying and selling a house must be 48%.

Sunday, March 8, 2015

How long to boil 1 Liter of water in 1500 watts kettle

Solution:

Cp = 4.19 KJ/(kg·C)
This is the specific heat of water at 15 °C and 101.325 kPa atmospheric pressure.
This is the amount of energy required to raise the temperature of  1 kg  ( 1 Liter )  of water by 1 °C.

Density of water:

1 kg/Liter
1000 kg/cubic meter
1 metric ton/cubic meter
1 g/cubic centimeter
1 g/ml


Boiling water for coffee/tea:

1 Liter is approximately 4 cups (good for a family of four)
100 °C is the boiling point of water at a pressure of 1 atm (101.325 kPa)


Temperature of cold tap water and hot water:

cold tap water is around 15 °C
in most homes, hot water heaters are set at 60 °C (140 °F)


Heat Calculation Formula:


Q = m x Cp x (T2-T1)

where:
Q = heat energy required to boil water, KJ
m = mass of water, kg
Cp = specific heat of water, 4.19 KJ/(kg·C)
T2 = boiling point of water, 100 C
T1 = temperature of cold tap water, 15 C

Q = 1 kg x 4.19 KJ/(kg·C) x (100 C - 15 C)

Q = 357 KJ


Black and Decker Kettle Power Rating:

1500 watts heating power
1500 watts is equal to 1.5 KW (KJ/sec)



Time to boil 1 Liter (1 kg) of water from 15 C:


assuming no heat is lost,

time = Q/Power of kettle

time = 357 KJ/1.5 KJ per second

time = 238 seconds

time = 4 minutes


Note: under the same conditions,

a. boiling 2 Liters of water would double the time to boil --> 8 minutes
b. using twice the kettle power (3000 watts) requires only half the boiling time --> 2 minutes

 
Time to raise 1 Liter of water 1 degree Celsius


using the same 1500-watt kettle, and assuming no heat loss

Q = 1 kg x 4.19 KJ/(kg·C) x (1 C)

Q = 4.19 KJ


time = 4.19 KJ/1.5 KJ per second

time = 3 sec


Note:

The time required to raise the temperature of water 1 degree C is dependent on,
a. amount (mass) of water
b. power rating of kettle

Saturday, October 25, 2014

Current draw of 1500 watts electric water kettle


Appliance data:

Black & Decker electric water kettle
Model # KE1517SC
1.7 Liter (7 cups) Capacity
1500 Watts of power
120 Volts, 16 AWG power cord


How to calculate current draw of 1500 watts electric water kettle

Formula:


Power = Volts x Amperes

Power = Voltage x Current

Current = Power/Voltage


Using 220 volts of power:


Current = 1500 watts/220 volts

Current = 7 amperes


Using 110 volts of power:

Current = 1500 watts/110 volts

Current = 14 amps



Conclusion:


Current consumption is doubled using 110 volts

Boiling time for water is the same either 110 or 220 volts is used, because both uses 1500 watts

Boils water faster than a microwave

Boiling time at full capacity is approx. 5 minutes

Friday, October 17, 2014

How long 18v 3Ah lithium ion drill battery last until recharge


Given data:
DEWALT 1/4 inch, 18 volt
Cordless Drill Driver ($100 price)
Average Power consumption: 250 watts
Ave. Amperage/Current draw: 7 Amperes
No Load Speed: 0-4,000 RPM
Chuck Size: 1/4 inch (6mm)
Gear Reduction: Single
Maximum Torque: 1300 in-lbs (150 Nm)
Power Source: 18v 3Ah Lithium Ion battery
Battery Recharge time: 30 minutes


Calculation of Running Time:

(Example: Carpentry, Home Project Renovation)

If I use this power drill to drive 2 inch screws in wood,
how long does the 18 volt, 3 ampere hour capacity
Li Ion battery last until my next recharge?

Total Available Energy at full charge = 3 ampere hour = 180 ampere minutes

Average time to drive one 2 inch screw in wood: 3 seconds (0.05 minutes)

Average Energy used to drive one 2 inch screw = 7 ampere x .05 minutes = 0.35 Amp min

Battery Run Time = 180/0.35 =  500 minutes = 8 hours


Notes:
Recharge the battery after 8 hours of total usage
This calculation is based on drill being used on 2 inch screws only
Battery will last longer or shorter depending on load and application
The harder the task (bigger screws, harder wood, etc.),
the more current draw, the more power consumption,
the more energy required,
the lesser the battery life before the next recharge

Monday, September 29, 2014

Monthly Mortgage Payments - estimate Canada


Example data:

Downpayment = 5%
Interest/Mortgage rate = 4.5%
Private Mortgage Insurance (PMI) = 0.52%

Mortgage term = 5 years
Amortization term = 25 years

Property Tax = $3,000 per year
Property Insurance = $1500 per year


Note:
1. Mortgage, Property tax, Property insurance and PMI will increase with an increase in House Price (Mortgage Amount).
2. Figures below are for estimate and example purposes only.


Canada Home Total Monthly payment = Mortgage 

                                                                  + Property tax 
                                                                  + Property insurance
                                                                  + PMI



Home Price ---  Home Total Monthly Payment (approximate)


$300,000 --------- $2,100

$350,000 --------- $2,400

$400,000 --------- $2,700


$450,000 --------- $3,000  *** *** *** *** *** ***


$500,000 --------- $3,300

$550,000 --------- $3,600

$600,000 --------- $3,900



Observation:
For every
$50,000 increase in property price,
$300 is added to your total monthly home payment.


Tuesday, September 2, 2014

Comox Valley - Affordable homes, Temperate climate


Comox Valley city, town, village & communities:

Courtenay city
Comox town
Cumberland village
Royston
Union Bay
Fanny Bay
Black Creek
Merville
Denman Island
Hornby Island


Location Description
:

- temperate climate
- Comox town's summer temperatures average 22C (72F)
- dry, sunny summers
- Comox town's winter temperatures rarely fall below freezing
- mild, wet winters
- Comox annual precipitation averages 1,179 mm (46.42 in)
- Precipitation (mainly rain) occurs October to March

- rural, town, village living
- less expensive housing prices (British Columbia's most affordable)
- affordable, moderate cost of living
- modern amenities & facilities:
   Airport
   Hospital
   Shopping malls
   Stores


Grocery Stores:
   Valley Asian Foods chinese grocery - 526 Cliffe Ave, Courtenay, BC, V9N 2J4
   Quality Foods Comox - 2275 Guthrie Road, Comox, BCV9M 4A6
   Quality Foods Courtenay - 1002-2751 Cliffe Ave, Courtenay, BCV9N 2L8
   Thrifty Foods - 660 England Avenue, Courtenay, BCV9N 2N4
   Edible Island Whole Foods Market - 477 6th Street, Courtenay, BCV9N 1M4
   Seeds Food Market, Inc. - 2733A Dunsmuir Ave, Cumberland, BCV0R 1S0


Chinese Restaurants:

  Dynasty Chinese Buffet - 1320 Cliffe Avenue Courtenay, BC V9N2K4
  Golden Carriage Restaurant - 4788 5th Street Courtenay, BC V9N
  Lo's Garden - 430 Old Island Highway Courtenay, BC V9N3P4
  Mandarin Village Restaurant - 5 Street Courtenay, BC V9N1J5

Canadian Tire - 278 Old Island Hwy, Courtenay, BC V9N 3P1

Walmart - 3199 Cliffe Avenue, Courtenay, BC V9N 2L9

Costco - 588 Crown Isle Blvd, Courtenay, BC V9N 0A6

Tim Hortons - 789 Ryan Rd, Courtenay, BC V9N 3R6
Tim Hortons - 2451 Cliffe Ave, Courtenay, BC V9N 2L5
Tim Hortons - 394 Lerwick Rd, Courtenay, BC V9N 2Z4

McDonalds - 1799 Cliffe Ave, Courtenay, BC V9N 2K7
McDonalds - 3199 Cliffe Ave, Courtenay, BC V9N 2L9
McDonalds - 727 Anderton Rd, Comox, BC V9M 3Y6


Friday, August 8, 2014

BUYING HOME: Mortgages Basic Knowledge


PAYMENT FREQUENCY:
Semi-monthly = 24 payments per year
Accelerated bi-weekly = 26 payments per year
Accelerated weekly = 52 payments per year

Savings through Accelerated Payments:
* A shorter Amortization Term saves you money because you will pay less interest costs over the life of the mortgage.
* Save thousands of dollars in interest costs - while paying down your mortgage sooner!
Example:
  - save over $62,000 by paying $1,454 Accelerated Bi-weekly for 21 years
  - save over $63,000 by paying $727 Accelerated Weekly for 21 years   
  - no savings by paying $2,908 monthly for 25 years

Basis for Example:
Mortgage Amount: $500,000.00
Interest Rate Type: Fixed
Payment Amount: $2,908.03
Payment Frequency: Monthly
Amortization Period: 25 years
Interest Term: 5 years
Interest Rate: 5%


INTEREST COSTS:
Term Interest Cost = interest cost on a loan for a specified term (e.g. total interest at 4% fixed rate for 5 year term mortage)

Amortization Interest Cost = total interest cost of the loan for the whole amortization period (e.g. total interest for the entire 25 year amortization period)


VARIABLE INTEREST RATES
Variable Interest Rate = interest rates can change during the mortgage term depending on changes in market interest rates (bank’s prime lending rate)

Advantages of variable interest rate mortgages:
- interest rates on variable rate mortgages are often lower than fixed interest rate mortgages

Disadvantages of variable interest rate mortgages:

- unknown future, difficult to predict, changes with the politics, global news, war, etc.
- between 2000 and 2009, the Bank of Canada bank rate changed from 0.5% to 6%


FIXED RATE MORTGAGES
- interest rate is constant throughout the term (e.g. fixed 4% interest rate over the entire 5 year term)


CLOSED MORTGAGE

- fixed term mortgage

Advantages of Closed Mortgage:
- interest rates are generally lower than for open term mortgages
- savings on interest costs
- payoff your mortgage faster

Disadvantages of Closed Mortgage:
- prepayment charge if you renegotiate your interest rate
- prepayment charge if you prepay more than what is allowable


CONVERTIBLE CLOSED MORTGAGE

- same benefits as a closed mortgage, but can be converted to a longer, closed term at any time without prepayment charges


OPEN MORTGAGE
- open term mortgage

Advantages of Open Mortgage:
- sound decision if you are planning to pay off your mortgage in the short term (10 years or less)
- can be repaid either in part or in full, at any time, without prepayment charges
- can be converted to any other term, at any time, without prepayment charges

Disadvantages of Open Mortgage:
- interest rates are generally higher than closed mortgages because of the added pre-payment flexibility


FIXED MORTGAGE RATES (Aug 2014)
Convertible:
 
6 Month   3.140% 

Closed:
1 Year     3.140%
2 Year     3.040%     (can i get 2 year mortgage contract??, almost same as prime rate)
3 Year     3.750%
4 Year     4.540%    
5 Year     4.940%    
7 Year     5.750%
10 Year     6.750%    
25 Year     8.750%    

Open:
6 month     6.300%
1 year     6.300%


VARIABLE MORTGAGE RATES (Aug 2014)

Closed:
5 year     RBC Prime Rate + 0.000% ---> 3.030%
(based on today's Royal Bank of Canada Prime Rate of 3.000%)     

Open:
5 year     RBC Prime Rate + 1.000% ---> 4.030%
(based on today's Royal Bank of Canada Prime Rate of 3.000%)

      
Today's Royal Bank of Canada Prime Rate (08 August 2014):

RBC Prime Rate     3.000%
Date of change: 09 Sept 2010 
(subject to change without notice, at any time)

*** Rates are applicable to residential mortgages only


MY MORTGAGE PREFERENCE:
Closed Mortage --> 25 years amortization
Variable Interest Rate --> 3% Prime Rate  ---> get 2 year fixed rate @ 3.040% ??
Accelerated Weekly --> save over $63,000 by paying $727 for 21 years     


500 K, 3% variable, 5 yr, closed mortgage, 25 yr amortization
 

500 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization

 
500 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization -FCAC
 

500 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization --FCAC

 
400 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization -FCAC


400 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization --FCAC


700 K, 5% fixed, 5 yr, closed mortgage, 25 yr amortization


700 K, 5%, 5 yr, closed mortgage, 25 yr amortization -FCAC


700 K, 5%, 5 yr, closed mortgage, 25 yr amortization -FCAC
  

Mortgage Rates, 08 Aug 2014



Canada Prime Interest Rates 2004-2014

 
Canada Prime Interest Rates 1960-2014




References:
https://www.rbcroyalbank.com/cgi-bin/mortgage/mpc/start.cgi
http://www.rbcroyalbank.com/rates/prime.html
http://www.rbcroyalbank.com/mortgages/mortgage-rates.html
http://www.fcac-acfc.gc.ca/eng/resources/publications/mortgages/Pages/Understa-Comprend-0.aspx#attractive
http://itools-ioutils.fcac-acfc.gc.ca/MC-CH/MC-CH-eng.aspx