In: Accounting
Problem 2
You have been very successful in business and it is time to buy the big boat so you can sail the blue seas of the Bedford basin and entertain your friends. You do your research and find the boat you want in Portugal. The price of the boat is $300,000 and it will cost $20,000 to have the boat delivered to Halifax. You go to the bank to borrow the entire amount of the purchase and the bank offers you a loan with a 20 year amortization at 5% with a 5 year term. You plan on making monthly payment on this loan.
a) | |||||
$ | |||||
Purchase cost of boat | 3,00,000 | ||||
Deliver cost | 20,000 | ||||
Entire cost of purchase the boat | 3,20,000 | ||||
Monthly payment based on PV factor @ 5% for 20 year | 2,112 | ||||
b) | |||||
Month/Year | Opening Balance | Interest @ .416% monthly | Principal | Closing Balance | |
(a) | (b) | (c=b*.416%) | (d=2112-c) | (e=b-d) | |
1 | 3,20,000 | 1,333 | 779 | 3,19,221 | |
2 | 3,19,221 | 1,330 | 782 | 3,18,439 | |
3 | 3,18,439 | 1,327 | 785 | 3,17,654 | |
4 | 3,17,654 | 1,323 | 789 | 3,16,865 | |
5 | 3,16,865 | 1,320 | 792 | 3,16,073 | |
6 | 3,16,073 | 1,317 | 795 | 3,15,278 | |
7 | 3,15,278 | 1,313 | 799 | 3,14,479 | |
8 | 3,14,479 | 1,310 | 802 | 3,13,677 | |
9 | 3,13,677 | 1,307 | 805 | 3,12,872 | |
10 | 3,12,872 | 1,303 | 809 | 3,12,064 | |
11 | 3,12,064 | 1,300 | 812 | 3,11,252 | |
12 | 3,11,252 | 1,297 | 815 | 3,10,436 | |
13 | 3,10,436 | 1,293 | 819 | 3,09,618 | |
14 | 3,09,618 | 1,290 | 822 | 3,08,795 | |
15 | 3,08,795 | 1,286 | 826 | 3,07,970 | |
16 | 3,07,970 | 1,283 | 829 | 3,07,141 | |
17 | 3,07,141 | 1,280 | 832 | 3,06,308 | |
18 | 3,06,308 | 1,276 | 836 | 3,05,472 | |
19 | 3,05,472 | 1,273 | 839 | 3,04,633 | |
20 | 3,04,633 | 1,269 | 843 | 3,03,790 | |
21 | 3,03,790 | 1,266 | 846 | 3,02,944 | |
22 | 3,02,944 | 1,262 | 850 | 3,02,094 | |
23 | 3,02,094 | 1,259 | 853 | 3,01,240 | |
24 | 3,01,240 | 1,255 | 857 | 3,00,383 | |
25 | 3,00,383 | 1,251 | 861 | 2,99,523 | |
26 | 2,99,523 | 1,248 | 864 | 2,98,659 | |
27 | 2,98,659 | 1,244 | 868 | 2,97,791 | |
28 | 2,97,791 | 1,241 | 871 | 2,96,919 | |
29 | 2,96,919 | 1,237 | 875 | 2,96,044 | |
30 | 2,96,044 | 1,233 | 879 | 2,95,166 | |
31 | 2,95,166 | 1,230 | 882 | 2,94,283 | |
32 | 2,94,283 | 1,226 | 886 | 2,93,397 | |
33 | 2,93,397 | 1,222 | 890 | 2,92,508 | |
34 | 2,92,508 | 1,219 | 893 | 2,91,614 | |
35 | 2,91,614 | 1,215 | 897 | 2,90,717 | |
36 | 2,90,717 | 1,211 | 901 | 2,89,816 | |
37 | 2,89,816 | 1,207 | 905 | 2,88,912 | |
38 | 2,88,912 | 1,204 | 908 | 2,88,003 | |
39 | 2,88,003 | 1,200 | 912 | 2,87,091 | |
40 | 2,87,091 | 1,196 | 916 | 2,86,175 | |
41 | 2,86,175 | 1,192 | 920 | 2,85,255 | |
42 | 2,85,255 | 1,188 | 924 | 2,84,332 | |
43 | 2,84,332 | 1,185 | 927 | 2,83,404 | |
44 | 2,83,404 | 1,181 | 931 | 2,82,473 | |
45 | 2,82,473 | 1,177 | 935 | 2,81,538 | |
46 | 2,81,538 | 1,173 | 939 | 2,80,598 | |
47 | 2,80,598 | 1,169 | 943 | 2,79,655 |
Related SolutionsScrutinize Zimbabwe’s economic policies after 1980. How successful have they been over time?[25 MARKS/ 5 PAGES]Scrutinize Zimbabwe’s economic policies after 1980.
How successful have they been over time?[25 MARKS/ 5
PAGES]
QUESTION 2 (2.5 + 2 + 3.5 + 2 = 10 marks) The length of time...QUESTION 2 (2.5 + 2 + 3.5 + 2 = 10
marks)
The length of time before roof tiles need replacing has a mean
of 20 years and a standard deviation of 6 years. The length of time
until a roof tile needs replacement is also found to have an
approximately normal distribution.
What is the proportion of roof tiles that last for more than 22
years? Show all working, define the variable, state the
distribution and give your answer...
For the last 10 years you have been working in the health food business. You have...For the last 10 years you have been working in the health food
business. You have talked to many customers who have suggested a
new restaurant concept. The restaurant would feature a variety of
low calorie meals (under 500) made from healthy ingredients
(organic fruits and vegetables and steroid/hormone free meat). The
restaurant would include a bar with an extensive organic wine list
and trendy décor. There would be an emphasis on high quality,
friendly service, and colorful meal presentation....
For the last 10 years you have been working in the health food business. You have...For the last 10 years you have been working in the health food
business. You have talked to many customers who have suggested a
new restaurant concept. The restaurant would feature a variety of
low calorie meals (under 500) made from healthy ingredients
(organic fruits and vegetables and steroid/hormone free meat). The
restaurant would include a bar with an extensive organic wine list
and trendy décor. There would be an emphasis on high quality,
friendly service, and colorful meal presentation....
For the last 10 years you have been working in the health food business. You have...For the last 10 years you have been working in the health food
business. You have talked to many customers who have suggested a
new restaurant concept. The restaurant would feature a variety of
low calorie meals ( under 500) made from healthy ingredients ( e.g.
organic fruits and vegetables and steroid/hormone free meat). The
restaurant would include a bar with an extensive organic wine list
and trendy décor. There would be an emphasis on high quality,
friendly service, and...
Problem Four (15 marks) You work for a small investment management firm. You have been provided...Problem Four
You work for a small investment management firm. You have been
provided with the following historical information for three stocks
and the market index. The information is shown in the table
below.
AAA Inc.
BBB Inc.
CCC Inc.
Stock Price
Dividend
Stock Price
Dividend
Stock Price
Dividend
Market Index
2012
$35
$1.20
$110
$0.45
$100
$1.50
10,840
2013
$40
$1.40
$120
$0.50
$85
$1.50
11,320
2014
$45
$1.40
$98
$0.55
$95
$1.60
12,220
2015
$50
$1.70
$115...
Allen Lie, Beverely Cheat and Hugo Steal have been partners in the very successful law firm...
Allen Lie,
Beverely Cheat and Hugo Steal have been partners in the very
successful law firm of
Lie, Cheat and Steal for many
years, however; they have decided to end their law practice
The balance sheet of Lie Cheat
and Steal on January 2nd 2017 when they decided to end their law
practice is as follows:
Steal is a 50% partner; Lie is
a 30% partner and Cheat is a 20% partner.
Balance Sheet
Lie, Cheat and Steal
January 2nd...
Allen Lie, Beverely Cheat and Hugo Steal have been partners in the very successful law firm...
Allen Lie,
Beverely Cheat and Hugo Steal have been partners in the very
successful law firm of
Lie, Cheat and Steal for many
years, however; they have decided to end their law practice
The balance sheet of Lie
Cheat and Steal on January 2nd 2017 when they decided to end their
law practice is as follows:
Steal is a 50% partner; Lie is
a 30% partner and Cheat is a 20% partner.
Balance Sheet
Lie, Cheat and Steal
January 2nd...
The owners of an e-business have been successful in selling fashion products but are now venturing...The owners of an e-business have been successful in selling
fashion products but are now venturing into another domain. Knowing
that the impact of advertising on profit cannot be overemphasized,
they are interested in determining the right amount to allocate to
advertising for the new business. Based on a monthly report from
the fashion e-business, a regression analysis of monthly profit (in
thousands of dollars) on advertising spending (in hundreds of
dollars) produced the following results: slope y-intercept r 1.26...
The owners of an e-business have been successful in selling fashion products but are now venturing...The owners of an e-business have been successful in selling
fashion products but are now venturing into another domain. Knowing
that the impact of advertising on profit cannot be overemphasized,
they are interested in determining the right amount to allocate to
advertising for the new business. Based on a monthly report from
the fashion e-business, a regression analysis of monthly profit (in
thousands of dollars) on advertising spending (in hundreds of
dollars) produced the following results:
slope
yy-intercept
rr
1.26...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|