AVERAGE and Financial ratios completed

xlsx

School

Lone Star College System, North Harris *

*We aren’t endorsed by this school

Course

4101

Subject

Computer Science

Date

Dec 6, 2023

Type

xlsx

Pages

8

Uploaded by DoctorDiscovery12969

Report
Each yellow cell requires a formula. The formula must only contain cell addresses. Each correct formula will begin with =, +, or -. The basic mathematical operators are +, -, * and / Using the AVERAGE function The AVERAGE function has the following syntax: =AVERAGE(Number 1, Number 2…) Order of operations When calculating a fraction, make sure to put parentheses around any formula used in either the nume For example =(B1+B2)/(C1+C2) Using absolute addresses Boxes of cereal 2 6 11 15 Price per box $3.95 Total cost $7.90 $23.70 $43.45 $59.25 Cell C28 =C26*$B$27 Cell D28 =D26*$B$27 Cell E28 =E26*$B$27 Click on the "Ratios" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1-B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1*B4 Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Remember the acronym PEMDAS when creating your formulas. P arentheses E xponents M ultiplication Once a formula is created, you will often want to copy the formula to other columns and rows. It's impo always uses "relative addresses" unless you indicate otherwise by creating an "absolute address". For e cost of purchasing 2 boxes of cereal at a cost of $3.95 per box, the formula in cell B28 is =B26*B27. Alth 2 boxes by $3.95", Excel is actually calculating the value in cell B28 as "Multiply the value in the cell in th above (row 26) by the value in the cell in the same column 1 row above (row 27). This works just fine to calculate the cost of 2 boxes, but if we copy the formula in cell B28 to C28, Excel w formula in cell C28 will become =C26*C27. Since Cell C27 is blank, the formula will return a value of $0 boxes of cereal, but it isn't accurate!) Adding a $ sign before the column or row reference locks the form If we modify the formula in cell B28 to =B26*$B$27 before we copy the formula, Excel will not change t variable. When the formula is copied to columns C through E, the formulas become: Sometimes, you will want the column to stay fixed, but allow the row to remain relative when it's copie column, but not the row (i.e.$B27) If you want the row to stay fixed, but allow the column to remain re sign before the row, but not the column (i.e. B$27). Tapping the F4 button while entering the formula (
erator or denominator. see your score. D ivision A ddition S ubtraction ortant to understand that excel example, if you are calculating the hough we read cell B28 as "Multiply he same column (column B) 2 rows will assume relative references. The (which is an excellent deal for 6 mula to a specific location. the row or the column of the second ed. If so, add a dollar sign before the elative when it's copied, add a dollar (or in the formula bar) toggles among
Name: Viviana Garza Your score: 100% Viviana Garza Company Comparative Income Statements For Years Ended December 31, 2027-2024 2027 2026 2025 2024 Net sales $306,000 $273,000 $237,000 $168,000 Cost of goods sold 141,000 235,000 153,000 141,000 Gross margin 165,000 38,000 84,000 27,000 Operating expenses 87,000 20,000 45,000 14,000 Net income $78,000 $18,000 $39,000 $13,000 Viviana Garza Company Comparative Balance Sheets For Years Ended December 31, 2027-2024 2027 2026 2025 2024 Cash $111,000 $129,000 $73,000 $136,000 Accounts receivable, net 86,000 76,000 66,000 47,000 Merchandise inventory 63,000 36,000 69,000 22,000 Plant assets, net 180,000 180,000 150,000 150,000 Total assets $440,000 $421,000 $358,000 $355,000 Current liabilities $42,000 $71,000 $46,000 $42,000 Long-term liabilities 190,000 220,000 200,000 240,000 Common stock 60,000 60,000 60,000 60,000 Retained earnings 148,000 70,000 52,000 13,000 Total liabilities and equity $440,000 $421,000 $358,000 $355,000 The Viviana Garza Company began operations in 2024. Its comparative income statements and balance sheets follow. Use a formula to calculate the ratios below. The AVERAGE formula must be used in any ratios using average accounts receivable, average inventory or average 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
Liquidity and Efficiency 2027 2026 2025 Current ratio 6.1905 3.3944 4.5217 Acid-test ratio 4.6905 2.8873 3.0217 Accounts receivable turnover 3.7778 3.8451 4.1947 Inventory turnover 2.8485 4.4762 3.3626 Total asset turnover 0.7108 0.7009 0.6648 Solvency 2027 2026 2025 Debt ratio 52.73% 69.12% 68.72% Equity ratio 47.27% 30.88% 31.28% Sum of Debt and Equity ratios 100.00% 100.00% 100.00% Debt-to-equity ratio $1.12 2.2385 2.1964 Profitability 2027 2026 2025 Profit margin ratio 25.49% 6.59% 16.46% Gross margin ratio 53.92% 13.92% 35.44% Return on total assets 18.12% 4.62% 10.94%
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

Python Data Representations Week2.docx
Python Data Representations Week1.docx
Basic Python Syntax Week3.docx
Strings Week1.docx
Basic Python Syntax Week1.docx
ECE 578 quiz 8.1 & 8.2.jpeg
Demetrius_assignment_10.rtf
SCS 100 Module One Activity Template (1) (2) (1).docx
case study.docx
HW3-DecisionTrees.docx
Lab2_2023_Questions.docx
Week 1_ Homework-Review.pdf
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
C++ Programming: From Problem Analysis to Program...
Computer Science
ISBN:9781337102087
Author:D. S. Malik
Publisher:Cengage Learning
Text book image
Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Text book image
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
SEE MORE TEXTBOOKS