Explore BrainMass
Share

# Ratio calculation

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

I am a little lost here are my problems please show me how to calculate

1. In March 2005, General Electric (GE) had a book value of equity of \$113 billion, 10.6 billion shares outstanding and a market price of \$36 per share. GE also had a cash of \$13 billion and total debt of \$370 billion. Four years later in early 2009, GE had a book value of equity of \$105 billion 10.5 billion shares outstanding with a market price of \$10.80 per share, cash of \$48 billion, and total debt of \$524 billion. Over this period what was the change in GEs

a. market capitalization
b. market to book ratio
c. book debt equity ratio
d. market debt equity ratio
c. enterprise value

2. In July 2007 Apple had cash of \$7.12 billion current assets of \$18.75 billion current liability of \$6.99 billion and inventories of \$0.25 billion.

a. What was Apples current ratio
b. what was apples quick ratio
c. in July 2007 Dell had a quick ratio of 1.25 and a current ratio of 1.30. What can you say about the asset liquidity of apple relative to dell?

https://brainmass.com/economics/finance/ratio-calculation-328326

#### Solution Preview

a. market capitalization
Market capitalization = Number of shares X market price per share
In 2005, market capitalization = 10.6 X 36 = \$381.6 billion
In 2009, market capitalization = 10.5 X 10.80 = \$113.4 billion
Change = 113.4-381.6 = -268.2 billion

b. market-to-book ratio

Market to book ratio = Market value/Book value
In 2005, market to book = 381.6/113 = 3.38
In 2009, market to book = 113.4/105 = 1.08
The ratio has ...

#### Solution Summary

The solution explains the calculation of various ratios

\$2.19

## Accounting

13-4
The following data have been collected for the past two years for the Northern Division of Loring Company:

2005 2006
Sales \$50,000,000 \$50,000,000
Operating Income 4,500,000 4,100,000
Average Operating Assets 25,000,000 25,000,000

REQUIRED:
1. COMPUTE THE MARGIN AND TURNOVER RATIOS FOR EACH YEAR.
2. COMPUTE THE ROI FOR EACH YEAR.
3. EXPLAIN WHY THE DIVISION EXPERIENCED A DECREASED A ROI FROM 2005 TO 2006.

13-6
CHERYL MANNERS, DIVISION MANAGER OF RADIOTECH, INC., WAS DEBATING THE MERITS OF A NEW PRODUCT-A WEATHER RADIO THAT WOULD PUT OUT A WARNING IF THE COUNTY IN WHICH THE LISTENER LIVED WAS UNDER A SEVERE THUNDERSTORM OR TORNADO ALERT. THE BUDGETED INCOME OF THE DIVISION WAS \$480,000 WITH OPERATING ASSETS OF \$8,000,000. THE PROPOSED INVESTMENT WOULD ADD INCOME OF \$270,000 AND WOULD REQUIRE AN ADDITIONAL INVESTMENT IN EQUIPMENT OF \$1,500,000.

REQUIRED
1. COMPUTE THE ROI OF:
A. THE DIVISION IF THE RADIO PROJECT IS NOT UNDERTAKEN
C. THE DIVISION IF THE RADIO PROJECT IS UNDERTAKEN

2. DO YOU SUPPOSE THAT CHERYL WILL DECIDE TO INVEST IN THE NEW RADIO? WHY OR WHY NOT?

16-2
SUPPOSE THAT THE ADAMS COMPANY SELLS A PRODUCT FOR \$16. UNIT COSTS ARE AS FOLLOWS:

DIRECT MATERIALS \$3.90
DIRECT LABOR \$1.40
VARIABLE SELLING EXPENSES \$1.60
TOTAL FIXED OVERHEAD IS \$52,000 PER YEAR, AND TOTAL FIXED SELLING AND ADMINISTRATIVE EXPENSES ARE \$37,950. NORMAL PRODUCTION IS 13,000 UNITS PER YEAR.
REQUIRED:
MATCH A TERM FROM COLUMN A WITH THE CORRECT NUMBER BASED ON THE ABOVE INFORMATION FOR ADAMS COMPANY IN COLUMN B.

# COLUMN A COLUMN B
1 CONTRIBUTION MARGIN A. 12,850
2 CONTRIBUTION MARGIN RATIO B. 0.5625
3 VARIABLE COST RATIO C. \$9.00
4 BREAK-EVEN UNITS D. 0.4375
5 PRIME COST PER UNIT E. \$7.50
6 CONVERSION COST PER UNIT F. \$7.00
7 VARIABLE COST PER UNIT G. \$5.30
16-4
THE CONTROLLER OF KERRISK COMPANY PREPARED THE FOLLOWING PROJECTED INCOME STATEMENT:
SALES (5,000 UNITS @ \$15) \$75,000
LESS: VARIABLE COSTS 60,000
CONTRIBUTION MARGIN 15,000
LESS: FIXED COSTS 10,350
OPERATING INCOME 4,650

REQUIRED:
1. WHAT IS THE CONTRIBUTION MARGIN PER UNIT FOR KERRISK COMPANY? WHAT IS THE CONTRIBUTION MARGIN RATIO?
2. WHAT IS THE VARIABLE COST RATIO FOR KERRISK COMPANY?
3. CALCULATE THE BREAK- EVEN REVENUE.
4. HOW MUCH REVENUE MUST KERRISK MAKE TO ERAN OPERATING INCOME EQUAL TO \$9,900?

17-7
SHERWOOD COMPANY IS CURRENTLY MANUFACTURING PART Z911, PRODUCING 40,000 UNITS ANNUALLY. The part is used in the procution of several products made by Sherwood. The cost per unit for z911 is as follows:

DIRECT MATERIALS \$9.00
DIRECT LABOR 3.00
TOTAL \$18.50

OF THE TOTAL FIXED OVERHEAD ASSIGNED TO Z911, \$88,000 IS DIRECT FIXED OVERHEAD (THE LEASE OF PRODUCTION MACHINERY AND SALARY OF A PRODUCTION LINE SUPERVISOR- NIETHER OF WHICH WILL BE NEEDED IF THE LINE IS DROPPED). THE REMAINING FIXED OVERHEAD IS COMMON FIXED OVERHEAD. AN OUTISDE SUPPLIER HAS OFFERED TO SELL THE PART TO SHEWOOD FOR \$16. THERE IS NO ALTERNATIVE USE FOR THE FACILITIES CURRENTLY USED TO PRODUCE THE PART.
REQUIRED:
1. SHOULD SHERWOOD COMPANY MAKE OR BUY PART Z911?
2. WHAT IS THE MOST SHERWOOD WOULD BE WILLING TO PAY AN OUTSIDE SUPPLIER?
3. IF SHERWOOD BOUGHT THE PART, BY HOW MUCH WOULD INCOME INCREASE OR DECREASE?

18-2
EACH OF THE FOLLOWING PARTS IS INDEPENDENT. ASSUME ALL CASH FLOWS ARE AFTER-TAX CASH FLOWS.
1. KAYLIN DAY HAS JUST INVESTED \$480,000 IN A BOOK AND VIDEO STORE. SHE EXPECTS TO RECEIVE AN INCOME OF \$144,000 PER YEAR FROM THE INVESTMENT. WHAT IS THE PAY-BACK PERIOD FOR KAYLIN?
2. JAN BOOTH PLACED \$128,000 IN A 3 YR SAVINGS PLAN. THE PLAN PAYS 5 PERCENT, AND SHE CANNOT WITHDRAW THE MONEY EARLY WITHOUT A PENALTY. ASSUMING THAT JAN LEAVES THE MONEY IN THE PLAN FOR THE FULL THREE YEARS, HOW MUCH MONEY WILL SHE HAVE?
3. COLBY HEPWORTH, MANAGER OF THE FEDER CREDIT UNION, IS CONSIDERING THE PURCHASE OF A NEW AUTOMATED TELLER SYSTEM. THE CASH BENEFITS WILL BE \$208,000 PER YEAR. THE SYSTEM COSTS \$1,088,000 AND WILL LAST TEN YEARS. COMPUTE THE NPV SUMING A DISCOUNT RATE OF 12 PERCENT. SHOULD THE BANK BUY THE NEW TELLER SYSTEM?
4. EMILY HANSEN HAS JUST INVESTED \$200,000 IN A COMPANY. SHE EXPECTS TO RECEIVE \$32,200 PER YEAR FOR THE NEXT EIGHT YEARS. HER COST OF CAPITAL IS 6 PERCENT. COMPUTE THE INTERNAL RATE OF RETURN. DID EMILY MAKE A GOOD DECISION?

View Full Posting Details