Week 4
docx
keyboard_arrow_up
School
Western University *
*We aren’t endorsed by this school
Course
1010
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by ChancellorElectronNarwhal28
Week 4 – October 5 – October 9 – Live ZOOM Class TOPIC 1: Loan Needs, Seasonality, Sensitivity, Risk Assessment, Decisions (pg. 82 ‐ 87)
Read: Financial Management (pg. 125- 131)
Case: Maple Leaf Hardware Ltd.
Assignment:
1.
As Stuart Foreman, assess Maple Leaf’s financial position, given the cash flow and financial ratio
information. 2.
Prepare a full set of projected statements. 3.
Discuss any seasonal effects on the company’s financing requirements. 4.
Considering inventory, AR & AP, which account is most sensitive to an increase or decrease in days? Why? How will a change in this account impact working capital needs? Hint
: What will be the impact on the plug if days of inventory increases/decreases 15 days? Discuss the appropriateness of the loan. 5.
Given the information that Stuart Foreman has before him, how much cash does Maple Leaf Hardware need?
6.
Perform a risk assessment on Maple Leaf Hardware. How will this analysis impact your decision?
7.
What recommendations would you make regarding Maple Leaf Hardware’s loan request? Why? TOPIC 2:
Cash Flow & Ratio Analysis
Case: Gardiner Wholesalers (A) (pg. 113-122)
Assignment:
1.
Analyze the cash flow statement and financial ratios for Elegance Jewellers. Elegance Jewellers’ ratios for Gardiner Wholesalers are available on OWL. 2.
Assess the overall financial position of Gardiner Wholesalers. TOPIC 3:
Projected Financial Statements
Case: Gardiner Wholesalers (B) (pg. 123-124)
Assignment:
1.
Prepare a set of projected financial statements for Elegance Jewellers. 2.
What are the future financial requirements for the company? What does your plug suggest?
3.
As Kathy Wilson, what recommendations would you make to the credit and sales managers regarding Elegance’s credit policy? WATCH: Gardiner A & B Case Class – Video Link on OWL -
Prepare the cases BEFORE viewing video link on OWL Complete prior to October 5
th
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
Window
Help
A education.wi
am 1
WP NWP Assessment Player UI Application
Question 28 of 42
View Policies
Current Attempt in Progress
In a service-type business, revenue is considered recognized
when the service is performed.
at the end of the year.
at the end of the month.
when cash is received.
Save for Later
arrow_forward
SCORE:
SECTION:
PROFESSOR:
Problem #21
Preparation of Financial Statements
2019:
Accounts Payable
Accounts Receivable
Accumulated Depreciation-Equipment
Allowance for Uncollectible Accounts
Cash
Calamba, Capital
Calamba, Drawing
Equipment
Transportation In
General Expenses (control)
Interest Expense
Merchandise Inventory, December 31
Notes Payable
Prepaid Insurance
P 677,820
545,070
462,870
18,790
132,310
612,000
326,400
753,150
224,880
149,390
35,000
1,320,420
299,000
7,350
5,407,160
43,050
259,600
499,600
Purchases
Purchases Discounts
Purchases Returns and Allowances
Santiago, Capital
Santiago, Drawing
Sales
Sales Returns and Allowances
244,800
7,155,000
375,750
385,880
Selling Expenses (control)
There were no changes in the partners' Capital accounts during the year. The
merchandise inventory at the beginning of the year was P1,440,590. The partnership
agreement provides for salary allowances of P330,000 for Calamba and P290,000 for
Santiago. It also stipulates an interest allowance…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
View Assessment
se data from Rollaird
Live balance sheets, perform a
Use Chapter 13 "Financial
ture" as a guidance.
g your numbers, use whole
ation, and one decimal point
een in the example below. The
ht red if incorrect after clicking
bottom right corner).
Terminology Matching - Academic Resources
EHCS380 Week 4 Horizontal and Vertical Analysis
00
multimedia.phoenix.edu
b Answered: Terminology Matching Independent... | bartleby
Accounts Receivable
Inventory
Total Assets
DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical
analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance.
Dec. 31, 2022
460,000
780,000
3,164,000
Example:
Dec. 31, 2021
Accounts Receivable 2022
400,000
650,000
2,800,000
NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point
for the answer, as seen in the example below. The text box will highlight red if incorrect after
clicking the Submit button (bottom right corner).…
arrow_forward
Cashaun Wo x
CCU
brightspace.wiltech.edu/d2l/le/7659/discussions/topics/2429/View
Subscribe
New Wave Images is a graphics design firm that prepares its financial statements using a calendar year.
Manny Kinn, the company treasurer and vice president of finance, has prepared a classified balance sheet
as of December 31. In January, this balance sheet will be submitted along with an application for a loan
from First Peoples Community Bank. An excerpt from the balance sheet follows:
Cash
$ 25,000
Accounts Receivable
85,000
Total Assets
$ 250,000
The accounts receivable balance includes a $56,000 loan to Tom Morrow, the company president. Tom
borrowed the money from New Wave 18 months earlier for a down payment on a new home. Tom has
orally assured Manny that he will pay off the loan within the next year. Because Tom is the company
president, Manny treats the amount due as a trade account receivable. In addition, Manny knows that the
bank will consider a large balance in trade accounts…
arrow_forward
How do i go about setting this up?
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Overview
Plans
Resources
Follow-up and reports
360° reports
PFR Final Exam
01-10 11
Question 43
Paying the minimum amount every month on a credit card will
Your answer:
pay a large percentage of the total amount owed every month
make the final amount paid substantlally higher than the amount initlally charged
O Help the cardholder create a plan for paying off a credit card in a decent amount of time.
Allow the card holder to avoid paying any interest charges.
Clear answer
Back
Next
Play Sto
arrow_forward
Accounting Homework
arrow_forward
hello tutor solve this question General accounting question
arrow_forward
Quality of initial posting
15
Frequency of responses to classmates
2.5
Quality of responses to classmates
2.5
Reference to supporting readings
2.5
Language and grammar
2.5
Total
25
arrow_forward
A
B
C
D
E
F
G
K
M
N O
P
Formula: Divide; Cell Referencing
Using Excel to Perform Vertical Analysis
Student Work Area
PROBLEM
Required: Provide input into cells shaded in yellow in this template. Use mathematical
formulas with cell references to this work area.
Data from the comparative balance sheets of Rollaird Company is
presented here.
December 31,
December 31,
Using these data from the comparative balance sheets of Rollaird Company, perform vertical
analysis.
2022
2021
Accounts receivable (net)
2$
460,000 $
400,000
1.
December 31, 2021
Inventory
Total assets
780,000
650,000
December 31, 2022
3,164,000
2,800,000
Amount
Percent
Amount
Percent
Accounts receivable (net)
$ 460,000
$
400,000
Inventory
780,000
650,000
Total assets
3,164,000
2,800,000
arrow_forward
Horizontal analysis
arrow_forward
Hello tutor please provide correct answer general Accounting question
arrow_forward
Pls help me :<
arrow_forward
←
A
Excel II Assignment_Data_1-1
B
C
D
E
F
G
Borrower's
Loan
Interest
Payment
1
Name
Amount
rate
years
2
James
$22,500
8%
5
3
Mike
$25,000
6%
5
4
John
$31,000
8%
5
5
Elison
$30,000
7%
5
6
Anna
$35,000
8%
5
7
8
9
10
11
12
13
14
15
16
17
18
19
Monthly
Payment
arrow_forward
MODUFAM
A v2.cengagenow.com
nical College
B Learning Module 8 - ACCT1105: Financial Accounting II (..
ECengageNOWv2| Online teaching
еBook
Show Me How
Changes in Current Operating Assets and Liabilities
Jasneet Corporation's comparative balance sheet for current assets and liabilities was as follows:
Dec. 31, Year 2 Dec. 31, Year 1
Accounts receivable
$20,200
$22,900
Inventory
13,000
10,700
Accounts payable
10,900
9,400
Dividends payable
25,100
30,700
Adjust net income of $185,000 for changes in operating assets and liabilities to arrive at net cash flows from operating activities.
Feedback
Check My Work
Once you have calculated the changes in the current operating assets and liabilities determine what impact those changes would
For example if accounts receivable has increased from last year to this year does that mean the company has collected more cas
If accounts payable has decreased does that mean the company has more cash or less cash?
Check My Work
Previous
Save and Exit
Submit…
arrow_forward
12:52 S
ㅁ
expert.chegg.com/qna/au
Chegg
Hide student question
Student question
LTE
Skip Exit
+ 32
5G
Classify the following balance sheet items
under fixed assets, working capital,
shareholders' equity, or net debt: overdraft,
retained earnings, brands, taxes payable,
finished goods inventories, bonds.
Time Left: 01:59:57
Submit
|||
8
Training
arrow_forward
Screenshot attached
greatly appreicated
thanks
aw
t
4
arrow_forward
QUESTION:12
Harrah Company provided the following information for the month of
October:
Beginning cash balance: $35,000
Cash receipts: $460,000
Cash disbursements: $485,000
Harrah's policy is to keep a minimum end-of-the-month cash balance of
$30,000. How much will Harrah's need to borrow during October?
a. $20,000
b. $25,000
c. $10,000
d. $0
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning
Related Questions
- Window Help A education.wi am 1 WP NWP Assessment Player UI Application Question 28 of 42 View Policies Current Attempt in Progress In a service-type business, revenue is considered recognized when the service is performed. at the end of the year. at the end of the month. when cash is received. Save for Laterarrow_forwardSCORE: SECTION: PROFESSOR: Problem #21 Preparation of Financial Statements 2019: Accounts Payable Accounts Receivable Accumulated Depreciation-Equipment Allowance for Uncollectible Accounts Cash Calamba, Capital Calamba, Drawing Equipment Transportation In General Expenses (control) Interest Expense Merchandise Inventory, December 31 Notes Payable Prepaid Insurance P 677,820 545,070 462,870 18,790 132,310 612,000 326,400 753,150 224,880 149,390 35,000 1,320,420 299,000 7,350 5,407,160 43,050 259,600 499,600 Purchases Purchases Discounts Purchases Returns and Allowances Santiago, Capital Santiago, Drawing Sales Sales Returns and Allowances 244,800 7,155,000 375,750 385,880 Selling Expenses (control) There were no changes in the partners' Capital accounts during the year. The merchandise inventory at the beginning of the year was P1,440,590. The partnership agreement provides for salary allowances of P330,000 for Calamba and P290,000 for Santiago. It also stipulates an interest allowance…arrow_forwardPlease do not give solution in image format thankuarrow_forward
- View Assessment se data from Rollaird Live balance sheets, perform a Use Chapter 13 "Financial ture" as a guidance. g your numbers, use whole ation, and one decimal point een in the example below. The ht red if incorrect after clicking bottom right corner). Terminology Matching - Academic Resources EHCS380 Week 4 Horizontal and Vertical Analysis 00 multimedia.phoenix.edu b Answered: Terminology Matching Independent... | bartleby Accounts Receivable Inventory Total Assets DIRECTIONS: Using these data from Rollaird Company's comparative balance sheets, perform a vertical analysis. Use Ch. 13, "Financial Analysis: The Big Picture," as guidance. Dec. 31, 2022 460,000 780,000 3,164,000 Example: Dec. 31, 2021 Accounts Receivable 2022 400,000 650,000 2,800,000 NOTE: When entering your numbers, use whole numbers in the equation, and 1 decimal point for the answer, as seen in the example below. The text box will highlight red if incorrect after clicking the Submit button (bottom right corner).…arrow_forwardCashaun Wo x CCU brightspace.wiltech.edu/d2l/le/7659/discussions/topics/2429/View Subscribe New Wave Images is a graphics design firm that prepares its financial statements using a calendar year. Manny Kinn, the company treasurer and vice president of finance, has prepared a classified balance sheet as of December 31. In January, this balance sheet will be submitted along with an application for a loan from First Peoples Community Bank. An excerpt from the balance sheet follows: Cash $ 25,000 Accounts Receivable 85,000 Total Assets $ 250,000 The accounts receivable balance includes a $56,000 loan to Tom Morrow, the company president. Tom borrowed the money from New Wave 18 months earlier for a down payment on a new home. Tom has orally assured Manny that he will pay off the loan within the next year. Because Tom is the company president, Manny treats the amount due as a trade account receivable. In addition, Manny knows that the bank will consider a large balance in trade accounts…arrow_forwardHow do i go about setting this up?arrow_forward
- Please do not give solution in image format thankuarrow_forwardOverview Plans Resources Follow-up and reports 360° reports PFR Final Exam 01-10 11 Question 43 Paying the minimum amount every month on a credit card will Your answer: pay a large percentage of the total amount owed every month make the final amount paid substantlally higher than the amount initlally charged O Help the cardholder create a plan for paying off a credit card in a decent amount of time. Allow the card holder to avoid paying any interest charges. Clear answer Back Next Play Stoarrow_forwardAccounting Homeworkarrow_forward
- hello tutor solve this question General accounting questionarrow_forwardQuality of initial posting 15 Frequency of responses to classmates 2.5 Quality of responses to classmates 2.5 Reference to supporting readings 2.5 Language and grammar 2.5 Total 25arrow_forwardA B C D E F G K M N O P Formula: Divide; Cell Referencing Using Excel to Perform Vertical Analysis Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to this work area. Data from the comparative balance sheets of Rollaird Company is presented here. December 31, December 31, Using these data from the comparative balance sheets of Rollaird Company, perform vertical analysis. 2022 2021 Accounts receivable (net) 2$ 460,000 $ 400,000 1. December 31, 2021 Inventory Total assets 780,000 650,000 December 31, 2022 3,164,000 2,800,000 Amount Percent Amount Percent Accounts receivable (net) $ 460,000 $ 400,000 Inventory 780,000 650,000 Total assets 3,164,000 2,800,000arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning

Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning