BuntonMod2a
docx
keyboard_arrow_up
School
University of Cincinnati, Clermont College *
*We aren’t endorsed by this school
Course
FINANCIAL
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by Nbunton0725
Financial Management in Healthcare
Module 2a Application Exercises
Learning Objectives:
1) Perform trend analysis on an organization’s balance sheet.
2) Calculate an acid-test/quick ratio.
3) Calculate, analyze, and compare the debt ratio for an organization.
Directions: In order to receive the full points for each of the exercises below, you must show your work (i.e. show your formulas with the numbers inserted). All answers are to be rounded to the 10
th
place (one place past the decimal). Use the guidance provided within your text as to what type of value should be represented by the particular calculation. All labels must be provided (percentage, days, dollars, etc.) in your final answers.
Part I: Trend Analysis Review the balance sheet and calculate the trend (% of change) for each line item and fill in the correct numbers in the highlighted yellow areas of the table. To calculate the percentage change from year to year, use the following formula on page 49 of your finance text.
UC Health Balance Sheet
Reported Values ($)
2023
Reported Values ($)
2022
Trend
(% Change)
Assets
Current Assets
Cash
4, 100,500
3,005,250
Patient Accounts Receivable
5, 500,000
3, 575,000
Total Current Assets
9,600,500
6,580,250
Capital Assets
Land & Construction in Progress
350,000
200,000
Total Capital Assets
350,000
200,000
Total Assets
9,950,500
6,780,250
Liabilities
Current Liabilities
Accounts Payable and Accrued Expenses
568,000
397,000
Accrued Salaries 875,000
975,000
Total Liabilities
1,443,000
1,372,000
Is this a vertical or horizontal analysis? Why? Comment on one item within the balance sheet that should be investigated further to see why there is a difference between the years. What could be impacting the differences? Part II: Liquidity Ratios A) Quick Test Ratio Balance Sheet for UC Clinic for Year Ending June 30, 2023 (FY23)
Assets
Liabilities
Cash and Cash Equivalents (includes short-term investments)
$550,000
Accounts payable
$ 720,000
Accounts Receivable
$2,265,000
Notes payable
$ 375,500
Inventories
$465,000
Total Current Assets
$3,280.000
Total Current Liabilities
$ 1,095,500
Equipment
$ 852,000
Long-term debt
$2,850,000
Building
$2,470,000
Total liabilities
$3,745,500
Accumulated Depreciation
$ 346,000
Fund Balance
$2,802,500
Total Assets
$6,948,000
Total Liabilities & Fund
Balance
$10,493,500
Balance Sheet for UC Clinic for Year Ending June 30, 2022 (FY22)
Assets
Liabilities
Cash and Cash Equivalents (includes short-term investments)
$450,000
Accounts payable
$ 620,000
Accounts Receivable
$1,265,000
Notes payable
$ 275,500
Inventories
$365,000
Total Current Assets
$2,080.000
Total Current Liabilities
$ 895,500
Equipment
$ 752,000
Long-term debt
$1,850,000
Building
$1,470,000
Total liabilities
$2,745,500
Accumulated Depreciation
$ 246,000
Fund Balance
$1,802,500
Total Assets
$4,548,000
Total Liabilities & Fund
Balance
$7,293,500
Analyze the balance sheet to decide whether UC Clinic has sufficient cash on hand to pay its bills. Calculate the quick rate ratios for UC Clinic
for FY22 and FY23. Show your work as you might receive partial credit even if your final answer is incorrect. Provide a brief answer in narrative format and in your own words as to what this ratio says about UC Clinic and their ability to pay their bills in both FY22 and FY23. Part III: Debt Performance Ratios Using the data provided in UC Clinic’s balance sheets for FY22 and FY23, calculate the debt performance ratio for FY22 and FY23. You may refer to page 61 of the finance text to assist you with this calculation. Show your work as you might receive partial credit even if your final answer is incorrect. Provide a comparative statement between the two fiscal years (FY22 vs FY23) and explain what this means in terms of UC Clinic’s total debt to its total assets
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
SOUTH EAST-ASIA INSTITUTE OF TRADE AND TECHNOL0GY
LL
LEARNING MODULE FOR 1
SEMESTER
GRADE 12
BUSINESS FINANCE
STUDENT'S NAME:
STRAND & SECTION:
PART 4: ACTIVITY/APPLICATION
Suppose: The following income Statements and Cash Flow Statements of company A, B and C were presented to you.
Which do you think is a more attractive company? Why?
O STAED
rasoplast
arrow_forward
1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…
arrow_forward
LinkedIn Learning
Free App for Android
in
Question 3 of 14:
Select an answer:
The US GAAP provides rules and guidance
for what two primary financial reporting
purposes?
Return to course
recognition and measurement
risk assessment and presentation
recognition and presentation
Open
initial and subsequent measurement
Previous
Skip
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
Please see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.
arrow_forward
Strictly type-written
Required:
• Ledger
• Guide Questions
arrow_forward
Export PDF as long image without watermark
Export
FUNDAMENTALS OF ACCOUNTANCY BUSINESS AND MANAGEMENT 2
Self-Learning Activity 9
Name
Year/Block:
Date
Direction: Write your answers on the space provided at the back of this Self Learning Activity.
Learning Objective:
After reading the module, the learners shall be able to:
4. Describe the nature of a bank reconciliation statement.
5. Identify common reconciling items and describe each of them.
6. Analyze the effects of the identified reconciling items.
Reference: Quarter 1 Module 9 – Fundamentals of Accountancy, Business and Management 2
LEARNING ACTIVITY 9:1
Presented hereunder are the details of your Cash Receipts Journal, Cash Disbursements Journal and the Bank
Statement of Banco de Oro.
Cash Receipts Journal
O.R. Number
Amount
Payor
Odessa Alera
Date
0001
P 30,000
June 3
0002
0003
20,000
5,000
20
Arnold Navales
29
Juanita Nambatac
0004
10,000
30
Kyle Jamora
Cash Disbursements Journal
Check Number
Amount
Payee
Star 5 Grocery
DX…
arrow_forward
Make a textual information from this Enrollment by Key Stage
arrow_forward
Ethics case: Uncollectible Accounts
Introduction
The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5.
The assignment information is given below;
You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…
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
Dlhos - YouT
A Apex Learning
- Apex Learning - Courses
A https://course.apexlearning.com/public/activity/7001002/assessment
cial Literacy
1 7.1.2 Exam: Exam
Question 1 of 40
Which of these options for saving money offers the most liquidity?
A. A savings bond
B. A money market account
C. A piggy bank
D. A basic savings account
SUBMIT
E PREVIOUS
re to search
arrow_forward
Learning
SE MINDTAP
evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆
lomework
6300.
1
mancial Lailuialvi vi a spicoubnicel.
Hide Feedback
Correct
X
f6
Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan
to make your first deposit one year from today.
a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent.
4
b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations.
Round your answer to the nearest cent.
6
Hide Feedback
Incorrect
F
Check My Work Feedback
Review the FVAN definition and its equation.
Q Search
Understand the difference between an ordinary annuity and an annuity due.
Be careful about the order of mathematical operations if using the equation.
If using a financial calculator, be…
arrow_forward
Learning Task 1: Identify or classify the different account titles as to whether
they belong to Assets, Liabilities, Owners' Equity Revenue or Expense of the busi-
ness. Fill the amounts of the following SFP and SCI elements:
Sales
Current Assets
Noncurrent Assets
Current Liabilities
Noncurrent Liabilities
Expenses
Net Income (Loss)
Chart of Accounts
SCI ACCOUNTS
SFP ACCOUNTS
ASSETS
Account
INCOME
Acc.
No.
No.
410
Service Fees
110
Cash
420
Sales
120
Accounts Receivables
Interest Income
Gains
Allow for Bad debts
430
125
130
Notes Receivable
440
EXPENSES
140
Inventory
150
Prepayments
510
Cost of SAles
Freight-out
Building
Accum Depn-Bldg
160
515
165
520
Salaries Expense
LIABILITIES
210
Accounts payable
530
Utilities Expense
Notes Payable
Interest Payable
Salaries Payable
Utilities Payable
220
540
Bad Debts
Depreciation
Advertising Expense
230
545
240
550
250
560
Taxes and Licenses
Unearned Income
Interest Expense
Miscellaneous Expense
260
570
EQUITY
Owner's Capital
Owner's Drawing
580…
arrow_forward
Perform a categorical analysis on the majors of students enrolled in the MBA. Describe your findings.
arrow_forward
Financial Information Table
arrow_forward
lem Set: Modx
* CengageNOWv2 | Onl X
* Cengage Learning
B Milestone Two Guideli x
G module
ow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=..
eBook
Show Me How
Quick ratio
Adieu Company reported the following current assets and current liabilities for two recent years:
Dec. 31, 20Y4 Dec. 31, 20Y3
Cash
$830
$1,090
Temporary investments
1,200
1,500
Accounts receivable
820
910
Inventory
2,100
2,500
Accounts payable
1,900
2,500
a. Compute the quick ratio on December 31 for each year. Round to one decimal place.
20Υ4
20Υ3
Quick Ratio
b. Is the quick ratio improving or declining?
Check My Work
56°F Mostly
39
arrow_forward
Comprehensive Problem 1Part 5: Work Sheet
The following is a comprehensive problem which encompasses all of the elements learned in previous chapters. You can refer to the objectives for each chapter covered as a review of the concepts. Note: You must complete parts 1, 2, 3, 4 before completing part 5.
Part 5: Enter the unadjusted trial balance on an end-of-period spreadsheet (work sheet) and complete the spreadsheet using the following adjustment data.
Insurance expired during May is $275.
Supplies on hand on May 31 are $715.
Depreciation of office equipment for May is $330.
Accrued receptionist salary on May 31 is $325.
Rent expired during May is $1,600.
Unearned fees on May 31 are $3,210.
If an amount box does not require an entry, leave it blank or enter "0".
Kelly ConsultingEnd-of-Period Spreadsheet (Work Sheet)For the Month Ended May 31, 20Y8
Unadjusted Trial Balance
Adjustments
Adjusted Trial Balance
Income Statement
Balance Sheet
Account Title
Debit
Credit
Debit…
arrow_forward
in
CengageNOWv2| Online teachi x
Cengage Learning
8-1 Problem Set: Module Eight X
how.comn/akeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=D&inprogress3false
eBook
Show Me How
Changes in Current Operating Assets and Liabilities-Indirect Method
Covington Corporation's comparative balance sheet for current assets and liabilities was as follows:
Dec. 31, 20Y2
Dec. 31, 20Y1
Accounts receivable
$15,300
Inventory
66,500
67,200
Accounts payable
20,100
0098
Dividends payable
000'
Adjust net income of $84,200 for changes in operating assets and liabilities to arrive at net cash flow from operating activities.
( Previou:
Check My Work
レ
AD
12
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
Digital Learning
* CengageNOwv2 | Online teachir
* Cengage Learning
+
Assignment/takeAssignmentMain.do?invoker=&takeAssignmentSessionLocator=&inprogress=false
A eBook
Show Me How
Percent of Sales Method
At the end of the current year, Accounts Receivable has a balance of $555,000; Allowance for Doubtful Accounts has a credit balance of $5,000; and sales for
the year total $2,500,000. Bad debt expense is estimated at 1/4 of 1% of sales.
a. Determine the amount of the adjusting entry for uncollectible accounts.
b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense.
Accounts Receivable
24
Allowance for Doubtful Accounts
Bad Debt Expense
%24
c. Determine the net realizable value of accounts receivable.
Feedback
Check My Work
a. Remember that since accounts receivable are created by credit sales, uncollectible accounts çan be estimated as a percent of credit sales. If the
portion of credit sales to sales id relatively constant, the…
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

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

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning
Related Questions
- SOUTH EAST-ASIA INSTITUTE OF TRADE AND TECHNOL0GY LL LEARNING MODULE FOR 1 SEMESTER GRADE 12 BUSINESS FINANCE STUDENT'S NAME: STRAND & SECTION: PART 4: ACTIVITY/APPLICATION Suppose: The following income Statements and Cash Flow Statements of company A, B and C were presented to you. Which do you think is a more attractive company? Why? O STAED rasoplastarrow_forward1. Journal all transactions in Part One 2. Using the chart of accounts, open ledger accounts and post journals to the ledger account. 3. Prepare a trial balance 4. Prepare the following statements: 1. Income Statement 2. Retained Earnings Statements 3. Balance Sheet You need to use Microsoft Excel. Do not use Google Docs or Apple’s numbers. Place your submission in the appropriate journal labeled final project in the learning modules tab in Blackboard. The project is due in Module 15. Three points extra credit to final grade if submitted during Module 14. Part One A. The following transaction occurred for Scrooge Inc. for the month of December 31, 1820. B. Ebenezer Scrooge invested $50,000 cash along in the company in exchange for common stock. C. The company prepaid $500 for 12 month’s rent. D. The company purchased $100 in office supplies. Payment due withing 10 days E. Scrooge Inc. completed services for a client and immediately received $2,000. F. The company completed $1,500…arrow_forwardLinkedIn Learning Free App for Android in Question 3 of 14: Select an answer: The US GAAP provides rules and guidance for what two primary financial reporting purposes? Return to course recognition and measurement risk assessment and presentation recognition and presentation Open initial and subsequent measurement Previous Skiparrow_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,000arrow_forwardPlease see below. I need help with this excel sheet. Note, please be sure to use cell referencing and the appropriate formulas for each part.arrow_forwardStrictly type-written Required: • Ledger • Guide Questionsarrow_forward
- Export PDF as long image without watermark Export FUNDAMENTALS OF ACCOUNTANCY BUSINESS AND MANAGEMENT 2 Self-Learning Activity 9 Name Year/Block: Date Direction: Write your answers on the space provided at the back of this Self Learning Activity. Learning Objective: After reading the module, the learners shall be able to: 4. Describe the nature of a bank reconciliation statement. 5. Identify common reconciling items and describe each of them. 6. Analyze the effects of the identified reconciling items. Reference: Quarter 1 Module 9 – Fundamentals of Accountancy, Business and Management 2 LEARNING ACTIVITY 9:1 Presented hereunder are the details of your Cash Receipts Journal, Cash Disbursements Journal and the Bank Statement of Banco de Oro. Cash Receipts Journal O.R. Number Amount Payor Odessa Alera Date 0001 P 30,000 June 3 0002 0003 20,000 5,000 20 Arnold Navales 29 Juanita Nambatac 0004 10,000 30 Kyle Jamora Cash Disbursements Journal Check Number Amount Payee Star 5 Grocery DX…arrow_forwardMake a textual information from this Enrollment by Key Stagearrow_forwardEthics case: Uncollectible Accounts Introduction The purpose of this discussion forum is to give you an opportunity to apply your critical-thinking ability to the knowledge you’ve gained. The assignment provides you with an opportunity to develop your research, analysis, judgment, and communication skills. You also will work with other students, integrate what you’ve learned, apply it in real-world situations. This practice will broaden your knowledge and further develop your decision-making abilities. The assignment achieves learning objective 5. The assignment information is given below; You have recently been hired as the assistant controller for Stanton Industries, a large, publicly held manufacturing company. Your immediate superior is the controller who, in turn, is responsible to the vice president of finance. The controller has assigned you the task of preparing the year-end adjusting entries. In the receivables area, you have prepared an aging of accounts receivable and have…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_forwardDlhos - YouT A Apex Learning - Apex Learning - Courses A https://course.apexlearning.com/public/activity/7001002/assessment cial Literacy 1 7.1.2 Exam: Exam Question 1 of 40 Which of these options for saving money offers the most liquidity? A. A savings bond B. A money market account C. A piggy bank D. A basic savings account SUBMIT E PREVIOUS re to searcharrow_forwardLearning SE MINDTAP evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆ lomework 6300. 1 mancial Lailuialvi vi a spicoubnicel. Hide Feedback Correct X f6 Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan to make your first deposit one year from today. a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 4 b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 6 Hide Feedback Incorrect F Check My Work Feedback Review the FVAN definition and its equation. Q Search Understand the difference between an ordinary annuity and an annuity due. Be careful about the order of mathematical operations if using the equation. If using a financial calculator, be…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

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

Financial Reporting, Financial Statement Analysis...
Finance
ISBN:9781285190907
Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Publisher:Cengage Learning