As4FIN8200 Assignment 4
docx
keyboard_arrow_up
School
Conestoga College *
*We aren’t endorsed by this school
Course
FIN-8165
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by PrivatePanther3948
FIN8200: Assignment #4 – Asset Allocation
For this assignment, you will be doing an analysis of Jim and Pam’s Asset Allocation. To assist in completing this analysis, you will need to reflect on your solutions for the first two exercises (Goals, Cash Flow and Net Worth). You will also need to refer to the FP Canada Guidelines 2023.
Part 1: Asset Allocation Analysis (9 marks)
a)
What would Jim’s Asset Mix be based on his current investments? What would Pam’s Asset Mix be based on her current investments? Show your calculation and present the result in a pie chart. Do the same for their jointly owned investments and comment on the in-trust account (tax implications?).
b)
Based on this Asset Mix, what would be the expected rate of return of each of their overall portfolios? Use FP Canada Guidelines 2023 to calculate the return. Show how you calculated this return.
c)
Would you recommend a different Asset Mix for Jim and Pam? Use FP Canada Guidelines 2023 to calculate the return on your proposed portfolio and show how you calculated it. Part 2: Pulling it All Together (3 marks)
Prepare a report (1 page maximum) for the Halperts that summarizes:
Their current asset allocation and expected rate of return.
Your recommended Asset Mix, in general, for both.
Do you need more information before a final recommendation? Do the goal(s) linked to a given investment impact the asset mix recommendation? Be specific about which goals and
why you chose a certain asset mix based on an investment objective (Hint: Review Client Objectives and Goals in Chapter 5).
Rubric
Asset Allocation Analysis /9 (3 marks for each question)
Pulling it All together
/3
Total
/12
0
Not professional, many grammar/spelling issues, most planning points/application and calculations not accurate and/or appropriate 1
Somewhat professional, many grammar/spelling issues, many planning points/application and calculations not accurate and/or appropriate 2
Mostly professional, a few grammar/spelling issues, most planning points/application and calculations accurate and appropriate 3
Professional, minimal grammar/spelling issues, almost all planning points/application and calculations accurate and appropriate
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
Related Questions
Answer all questions
arrow_forward
Need help on b. How to show this on a balance sheet in excel.
arrow_forward
!
Required information
[The following information applies to the questions displayed below.]
Turtle Creek Partnership had the following revenues, expenses, gains, losses, and distributions:
Sales revenue
Long-term capital gains
Cost of goods sold
Depreciation-MACRS
Amortization of organization costs.
Guaranteed payments to partners for general management
Cash distributions to partners
$ 65,500
$ 4,800
Ordinary income (loss)
$ (22,100)
$ (7,900)
$ (1,240)
$ (15,600)
$ (3,600)
a. Given these items, what is Turtle Creek's ordinary business income (loss) for the year?
arrow_forward
Given the following information for Jane Brown, lawyer, calculate the value of J. Brown, Capital as ofDecember 31, 2022. Please create a balance sheet.
arrow_forward
At December 31, 2020, Cord Company's plant asset and accumulated depreciation and amortization accounts had balances as follows:
Accumulated Depreciation
and Amortization
$
Category
Land
Land improvements
Buildings
Equipment
Automobiles and trucks
Leasehold improvements
Plant Asset
$ 180,000
1,750,000
1,375,000
177,000
226,000
333,900
322,500
105,325
113,000
Depreciation methods and useful lives:
Buildings-150% declining balance; 25 years.
Equipment Straight line; 10 years.
Automobiles and trucks-200% declining balance; 5 years, all acquired after 2017.
Leasehold improvements-Straight line.
Land improvements-Straight line.
Depreciation is computed to the nearest month and residual values are immaterial. Transactions during 2021 and other information:
a. On January 6, 2021, a plant facility consisting of land and building was acquired from King Corp. in exchange for 30,000 shares of Cord's common stock. On this date, Cord's stock had a fair value of $40 a share. Current
assessed values…
arrow_forward
Answer the following using the FASB codification
arrow_forward
I dont not know how to solve this problem
arrow_forward
Can you walk me through this problem?
arrow_forward
Discuss how the results of Quick ratio and debt ratio will affect the organization's performance.
arrow_forward
Complete all of the following listed in the picture.
Such as:
General Journal
General Ledaer
Trial Balance
Income
Statement
Statement of SE
Balance Sheet
Analysis
Following an accountant format.
Including:
Compute the total asset turnover ratio for 2020....
Compute the net profit margin ratio for 2020...
arrow_forward
The fact that generally accepted accounting principles allow companies flexibility in choosing between certain allocation methods can
make it difficult for a financial analyst to compare periodic performance from firm to firm.
Suppose you were a financial analyst trying to compare the performance of two companies. Company A uses the double-declining-
balance depreciation method. Company B uses the straight-line method. You have the following information taken from the 12/31/2021
year-end financial statements for Company B:
Income Statement
Depreciation expense
$10,000
Balance Sheet
Assets:
Plant and equipment, at cost
Less: Accumulated depreciation
Net
$ 200,000
(40,000)
$ 160,000
You also determine that all of the assets constituting the plant and equipment of Company B were acquired at the same time, and that
all of the $200,000 represents depreciable assets. Also, all of the depreciable assets have the same useful life and residual values are
zero.
Required:
1. In order to compare…
arrow_forward
a) Prepare appropriate journal entries for each relevant event.
nearest dollar). Show your working.
b) What is a qualifying asset? Provide two (2) examples.
(Round amounts to the
arrow_forward
Please help me find the following numbers. Please find the Sales, COGS, Other Operating
expenses, and Depreciation & Amortization for the years 2020, 2021, and 2022 for Humana
Inc and The Cigna Group. Thank you! Please show me where you found the numbers (links if
possible!)
arrow_forward
Please Answer all, with solutions
arrow_forward
Cost to date
Estimated cost to complete
Total estimated cost
Percentage complete (Round)
to nearest whole number)
Total contract price
Total estimated cost
Estimated grass profit or lass
Revenue to recognize to date
Less Revenue previously
recognized
Revenue to recognize in year
Estimated grass profit to
recognize to date
Less Gross profit or loss
previously recognized
Gross profit or loss to
recognize in year
2022
2023
2024
$
S
%
%
%
arrow_forward
Exercise 14-36 (Algo) Comparing Business Units Using Economic Value Added (EVA) (LO 14-4)
Lauderdale Corporation is organized in three geographical divisions (regions) with managers responsible for revenues, costs, and
assets in their respective regions. The firm is highly decentralized and managers are evaluated solely on divisional performance.
Corporate overhead (all fixed) is allocated to the regions based on regional gross margin (regional revenue minus regional cost of
sales).
The following information is from Lauderdale's first year of operations:
Revenues
Cost of sales
Selling, General and
Administrative (all fixed)
Corporate overhead
Region I
$ 1,206,000
453,000
429,000
Region II
$ 1,656,000
813,000
639,000
R&D expenditures
Current liabilities
Information on the division assets in the three regions of Lauderdale Corporation follows:
Region III
$ 2,256,000
1,143,000
859,000
Region I
$ 706,000
Region II
636,000
1,296,500
Region III
Lauderdale Corporation has a cost of capital of…
arrow_forward
Please check the answer and add explanation properly at every steps and solve steps wise
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
Classified Balance Sheet:
Identify each of the following elements as a Current Asset (CA), Property, Plant & Equipment (PPE), Current Liability (CL), or Long-Term Liability (LTL)
Cash ________
Sales Tax Payable ________
Machinery ________
Note Payable (due in 2029) ________
Accumulated Depreciation ________
Salaries Payable ________
arrow_forward
In cell D22, by using cell references, calculate the total long-term assets for year 2014 Use the relevant cells from the given data in the balance sheet. In call D23, by using a cell reference, calculate the total assets for year 2014. Refer to the relevant cell from the given data in the balance sheet. Note: The total assets must equal the total liabilities and owners' equity." in cell D18, by using cell references, calculate the total current assets for year 2014. Use the relevant cells in the balance sheet. In cell D16, by using cell references, calculate the accounts receivable for year 2014. Use the relevant cells in the balance sheet, in cell H14, by using cell references, calculate the accounts payable for year 2014. Use the relevant cells from the given cata in the balance sheet. In cell H22, by using cell references, calculate the total owners' equity for year 2014. Use the relevant cells from the given data in the balance sheet. In cell H18, by using cell references,…
arrow_forward
Hh1.
arrow_forward
icerca
Dashboard
My courses
Which of these is an allowable cost of an asset under IAS 16?
1. Professional fees
2. General overheads
3. Cost of site preparation
4. Initial operating losses
5. Administration expenses
6. Decommissioning costs
O a.
1, 3 and 6
O b. 1, 3 and 5
O c. 1, 2 and 6
O d. 1, 2 and 4
O
Financial Reporting (level 5) (2022_23)
t
Y
ASUS ZenBook
Assessment
arrow_forward
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning
Related Questions
- Answer all questionsarrow_forwardNeed help on b. How to show this on a balance sheet in excel.arrow_forward! Required information [The following information applies to the questions displayed below.] Turtle Creek Partnership had the following revenues, expenses, gains, losses, and distributions: Sales revenue Long-term capital gains Cost of goods sold Depreciation-MACRS Amortization of organization costs. Guaranteed payments to partners for general management Cash distributions to partners $ 65,500 $ 4,800 Ordinary income (loss) $ (22,100) $ (7,900) $ (1,240) $ (15,600) $ (3,600) a. Given these items, what is Turtle Creek's ordinary business income (loss) for the year?arrow_forward
- Given the following information for Jane Brown, lawyer, calculate the value of J. Brown, Capital as ofDecember 31, 2022. Please create a balance sheet.arrow_forwardAt December 31, 2020, Cord Company's plant asset and accumulated depreciation and amortization accounts had balances as follows: Accumulated Depreciation and Amortization $ Category Land Land improvements Buildings Equipment Automobiles and trucks Leasehold improvements Plant Asset $ 180,000 1,750,000 1,375,000 177,000 226,000 333,900 322,500 105,325 113,000 Depreciation methods and useful lives: Buildings-150% declining balance; 25 years. Equipment Straight line; 10 years. Automobiles and trucks-200% declining balance; 5 years, all acquired after 2017. Leasehold improvements-Straight line. Land improvements-Straight line. Depreciation is computed to the nearest month and residual values are immaterial. Transactions during 2021 and other information: a. On January 6, 2021, a plant facility consisting of land and building was acquired from King Corp. in exchange for 30,000 shares of Cord's common stock. On this date, Cord's stock had a fair value of $40 a share. Current assessed values…arrow_forwardAnswer the following using the FASB codificationarrow_forward
- Complete all of the following listed in the picture. Such as: General Journal General Ledaer Trial Balance Income Statement Statement of SE Balance Sheet Analysis Following an accountant format. Including: Compute the total asset turnover ratio for 2020.... Compute the net profit margin ratio for 2020...arrow_forwardThe fact that generally accepted accounting principles allow companies flexibility in choosing between certain allocation methods can make it difficult for a financial analyst to compare periodic performance from firm to firm. Suppose you were a financial analyst trying to compare the performance of two companies. Company A uses the double-declining- balance depreciation method. Company B uses the straight-line method. You have the following information taken from the 12/31/2021 year-end financial statements for Company B: Income Statement Depreciation expense $10,000 Balance Sheet Assets: Plant and equipment, at cost Less: Accumulated depreciation Net $ 200,000 (40,000) $ 160,000 You also determine that all of the assets constituting the plant and equipment of Company B were acquired at the same time, and that all of the $200,000 represents depreciable assets. Also, all of the depreciable assets have the same useful life and residual values are zero. Required: 1. In order to compare…arrow_forwarda) Prepare appropriate journal entries for each relevant event. nearest dollar). Show your working. b) What is a qualifying asset? Provide two (2) examples. (Round amounts to thearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning