ACCT220 Portfolio Project - Shelley Final Submission
.xlsx
keyboard_arrow_up
School
Bryant & Stratton College *
*We aren’t endorsed by this school
Course
220
Subject
Accounting
Date
Jan 9, 2024
Type
xlsx
Pages
5
Uploaded by BailiffCheetahPerson1003
BRYANT & STRATTON COLLEGE
ACCT220 - FINANCIAL ANALYSIS
PORTFOLIO PROJECT
Introduction Page
Click Below to Access the spreadsheet you are looking for:
This spreadsheet will give you the account balances for Module 4.
The Ratios to calculate in Module 5.
The management assumptions to use to complete the Pro Forma income sta
Module 4
Module 5
Module 6
atement in Module 6.
BRYANT & STRATTON COLLEGE
ACCT220 FINANCIAL ANALYSIS
PORTFOLIO PROJECT
Module 4
ARRANGE THE FOLLOWING FINANCIAL INFORMATION INTO THE FOLLOWING:
1) Comparative Balance Sheets for 2020 vs. 2021.
2) Comparative Income Statements for 2020 vs. 2021.
3) Construct the 2021 Statement of Cash Flows using items 1 and 2.
2020 BALANCE
2021 BALANCE
Selling and Administrative Expenses
650,000
600,000
Interest Expense
54,000
52,000
Accounts Receivable (net)
350,000
425,000
Taxes
91,000
58,000
Notes Payable
200,000
175,000
Capital paid in excess of par
500,000
500,000
Cost of Goods Sold
2,300,000
2,250,000
Cash
120,000
95,000
Common Stock, $1 par value
250,000
250,000
Sales
3,600,000
3,300,000
Plant and Equipment
2,500,000
2,800,000
Accumulated Depreciation
850,000
950,000
Depreciation Expense
90,000
100,000
Retained Earnings
665,000
905,000
Bonds Payable, 2016
700,000
700,000
Accounts Payable
375,000
475,000
Operating Income
560,000
350,000
Accrued Expenses
80,000
60,000
Investments
150,000
100,000
Inventory
450,000
550,000
Prepaid Expenses
50,000
45,000
Click here to get back to the Introduction Page
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 Questions
From the dropdown box beside each numbered balance sheet item, select the option of its balance sheet classification. If the item should not appear on the balance sheet, choose the option "No item required" from the selection choices.
arrow_forward
13. Strategy 4 - Asset allocation
Asset allocation is the proportion of your overall investment portfolio that you have invested in various categories of assets. Typical asset categories include, for example, equities (stocks or stock mutual funds), bonds (or bond funds), and cash (or cash equivalents such as Treasury bills).
The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on various factors, such as your time horizon, your risk tolerance, and your investment philosophy:
Risk Tolerance/Investment Philosophy
Asset Allocation and Time Horizons
0–5 Years
6–10 Years
11+ Years
10% Cash
20% Bonds
100% Equities
High Risk/Aggressive
30% Bonds
80% Equities
60% Equities
20% Cash
10% Cash
20% Bonds
Moderate Risk/Moderate
40% Bonds
30% Bonds
80% Equities
40% Equities
60% Equities
35% Cash
20% Cash
10% Cash
Low Risk/Conservative
40% Bonds
40% Bonds…
arrow_forward
tor Subject Quiz - Course Hero x
coursehero.com
(-quiz/Finance/
Course Hero
Find
Browse
Find study resources
Ask
Study Resources v
Textbook Solutions
Expert Tutors
K Exit Test
Finance Knowledge Test (10 questions)
1. Which of the following are acceptable criteria for determining the weights in the weighted average cost of capital?
O Market value of the capital structure and historical costs of financing
Market value of the capital structure and the target mix of debt and equity
Using the after-tax cost of debt and the market value of the capital structure
Using the book value of the capital structure and the prior level of debt and equity
2. When a company increases its degree of financial leverage,
the equity beta of the company falls
the systematic risk of the company falls
the unsystematic risk of the company falls
the standard deviation of returns on the equity of the company rises
3. Calculate the degree of financial leverage for a firm with EBIT of $6,000,000, fixed cost of…
arrow_forward
Directions : research on the following financial analysis tool and give examples :
1. Horizontal Analysis of FS
arrow_forward
Case Questions
Directions: Using the data provided, and your knowledge of finance, answer all questions listed below. Qualitative questions can be addressed in a word document; calculations, including all work required for each question, should be submitted on an Excel spreadsheet.
Note on Question #6: NPV calculations should use the formula for TVM based on =NPV(rate, value 1, value 2...)+original purchase price as a negative. You DO NOT need to calculated the XNPV values.
Question #1What are the total revenues for Property 1?
Question #2What are the revenues for Property 2 in September 2019?
Question #3What are the costs for Property 3 in October 2020?
Question #4What are total revenues less total costs for Property 4a?
Question #5What is the absolute value of difference in operating costs between Properties 4a and 4b?
Question #6Using the provided data, calculate the NPV for each project.
Question #7: Analyzing your data from Property 4, should you complete the overhaul (choice B)…
arrow_forward
Only typed answer
arrow_forward
What is the investment objective for the following investments:
1. PRMX fund
2. VWELX fund
3. SPY ETF
4. MC.PA company
5. MSFT company
arrow_forward
Which of the following statements constitutes a definition of a financial plan?
Group of answer choices
Results that an individual wants to attain
2. A roadmap for achieving financial goals
3. Redefining your financial goals
4. Setting a goal date
arrow_forward
rayer.sop
- PRACTICE MILESTONE 1
A Practice Milestone PDF
8.
10
11
12
13
14
15
16
17
O This is a practice Milestone and does not count towar
Question
Unit 1 Tutorials
Question 1
The purpose of finance is to
create maximum value through informed resource decisions
understand how and why markets change
Oeliminate all risk and uncertainty when it comes to investing assets
O make as much money as possible over the long-term
SAVE AND CONTINUE
earch
arrow_forward
In five sentence define the following
1. Financial Planning
2. Financial Forecasting
arrow_forward
Financial Forecasting Assumptions – Financial forecasting projects a firm’s future financial needs. There are various methods used for forecasting. Discuss the various forecasting methods and the assumption that underlie each method.
arrow_forward
Only typing answer
Please explain step by step without table
arrow_forward
Match the words with the term.
Question 6 options:
12345
financial need
12345
risk capital
12345
internal source
12345
external sources
12345
financing requirement
1.
working capital
2.
subordinated debt
3.
lenders
4.
short-term debt
5.
retained earnings
arrow_forward
Typed plz and asap thanks please provide me. A quality solution take care of plagiarism
arrow_forward
The financial analysis is information system help us to:
Making decision
Portfolio Selection
O Financial management
O All of them
arrow_forward
Mc
Graw
Hill
Risk and Capital Budgeting
AA
Fill in the blank: Scenario analysis is made up of
several
Correct
Michael
Scenarios
Michael
We have created various scenarios each with
a forecast for our expected sales volume,
revenues, expenses, risks, etc.
At a high level, here are how each of the
scenarios looks like.
Calculate NPV for Scenario A.
Use the information provided on the right. Round to
the nearest whole number.
Submit
Enter a response then click Submit below
$0
Scenarios
Area 1.1
Scenario Comparison ($)
Scenario A
Scenario B
Scenario C
Initial
Investment
2,000,000
2,000,000
2,000,000
Expected interest rate: 12%
Forecasting period: 5 years
PV annuity factor: 3.6048
Annual Net
Income
545, 100
426,995
1,644,385
Annual Cash
Flow
656,890
-493, 005
2,564,385
NPV
-3,777, 184
7,244,095
Return to Activity
Score
Materials
arrow_forward
Please help on part a and it’s subparts and part b
arrow_forward
Q21
arrow_forward
Using the findings provide a brief summary about the financial status of each of the companies and provide a recommendation for the investment choice.
arrow_forward
Subject: Financial strategy & policy
Question No 1
Which are the three core areas for which a financial manager is expected to devise a financial policy? Explain them with examples.
How risk can be managed in those areas?
arrow_forward
Course Title: Principle of Healthcare Finance
The optimal capital structure decision is based on _____.
Asset structure
Industry averages
All of these
Financial Risk
arrow_forward
Why should a client provide their investment manager with an investment policy statement? Be specific.
Edit View
Insert
Format
Tools Table
arrow_forward
I've found out the EVA for each one as you can see but don't know how to calculate ROC. I think it's operating income/capital charge. Anyways I wanted to ask how I would solve part B which is telling me to examine. Can you tell me what you would do for B
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning
Related Questions
- From the dropdown box beside each numbered balance sheet item, select the option of its balance sheet classification. If the item should not appear on the balance sheet, choose the option "No item required" from the selection choices.arrow_forward13. Strategy 4 - Asset allocation Asset allocation is the proportion of your overall investment portfolio that you have invested in various categories of assets. Typical asset categories include, for example, equities (stocks or stock mutual funds), bonds (or bond funds), and cash (or cash equivalents such as Treasury bills). The following table illustrates several model portfolios that you can use as a basis for your own investment plan, depending on various factors, such as your time horizon, your risk tolerance, and your investment philosophy: Risk Tolerance/Investment Philosophy Asset Allocation and Time Horizons 0–5 Years 6–10 Years 11+ Years 10% Cash 20% Bonds 100% Equities High Risk/Aggressive 30% Bonds 80% Equities 60% Equities 20% Cash 10% Cash 20% Bonds Moderate Risk/Moderate 40% Bonds 30% Bonds 80% Equities 40% Equities 60% Equities 35% Cash 20% Cash 10% Cash Low Risk/Conservative 40% Bonds 40% Bonds…arrow_forwardtor Subject Quiz - Course Hero x coursehero.com (-quiz/Finance/ Course Hero Find Browse Find study resources Ask Study Resources v Textbook Solutions Expert Tutors K Exit Test Finance Knowledge Test (10 questions) 1. Which of the following are acceptable criteria for determining the weights in the weighted average cost of capital? O Market value of the capital structure and historical costs of financing Market value of the capital structure and the target mix of debt and equity Using the after-tax cost of debt and the market value of the capital structure Using the book value of the capital structure and the prior level of debt and equity 2. When a company increases its degree of financial leverage, the equity beta of the company falls the systematic risk of the company falls the unsystematic risk of the company falls the standard deviation of returns on the equity of the company rises 3. Calculate the degree of financial leverage for a firm with EBIT of $6,000,000, fixed cost of…arrow_forward
- Directions : research on the following financial analysis tool and give examples : 1. Horizontal Analysis of FSarrow_forwardCase Questions Directions: Using the data provided, and your knowledge of finance, answer all questions listed below. Qualitative questions can be addressed in a word document; calculations, including all work required for each question, should be submitted on an Excel spreadsheet. Note on Question #6: NPV calculations should use the formula for TVM based on =NPV(rate, value 1, value 2...)+original purchase price as a negative. You DO NOT need to calculated the XNPV values. Question #1What are the total revenues for Property 1? Question #2What are the revenues for Property 2 in September 2019? Question #3What are the costs for Property 3 in October 2020? Question #4What are total revenues less total costs for Property 4a? Question #5What is the absolute value of difference in operating costs between Properties 4a and 4b? Question #6Using the provided data, calculate the NPV for each project. Question #7: Analyzing your data from Property 4, should you complete the overhaul (choice B)…arrow_forwardOnly typed answerarrow_forward
- What is the investment objective for the following investments: 1. PRMX fund 2. VWELX fund 3. SPY ETF 4. MC.PA company 5. MSFT companyarrow_forwardWhich of the following statements constitutes a definition of a financial plan? Group of answer choices Results that an individual wants to attain 2. A roadmap for achieving financial goals 3. Redefining your financial goals 4. Setting a goal datearrow_forwardrayer.sop - PRACTICE MILESTONE 1 A Practice Milestone PDF 8. 10 11 12 13 14 15 16 17 O This is a practice Milestone and does not count towar Question Unit 1 Tutorials Question 1 The purpose of finance is to create maximum value through informed resource decisions understand how and why markets change Oeliminate all risk and uncertainty when it comes to investing assets O make as much money as possible over the long-term SAVE AND CONTINUE earcharrow_forward
- In five sentence define the following 1. Financial Planning 2. Financial Forecastingarrow_forwardFinancial Forecasting Assumptions – Financial forecasting projects a firm’s future financial needs. There are various methods used for forecasting. Discuss the various forecasting methods and the assumption that underlie each method.arrow_forwardOnly typing answer Please explain step by step without tablearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Survey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning