### Data for Jamestown Company- **Sales**: $3,650,000- **Total Asset Turnover**: 1.6x- **Current Ratio**: 4:1- **Quick Ratio**: 3:1- **Current Liabilities to Net Worth**: 30%- **Average Collection Period**: 25 days- **Total Debt to Total Assets**: 0.4### InstructionsFill in the balance sheet for the Jamestown Company based on the data provided above, assuming a 365-day year. Round your answers to the nearest dollar.### Balance Sheet Structure#### Assets- **Cash**: $ _____- **Accounts Receivable**: $ _____- **Inventory**: $ _____- **Total Current Assets**: $ _____- **Fixed Assets**: $ _____- **Total Assets**: $ _____#### Liabilities and Equity- **Accounts Payable**: $ _____- **Total Current Liabilities**: $ _____- **Long-term Debt**: $ _____- **Stockholders’ Equity**: $ _____- **Total Liabilities and Equity**: $ _____> Use the given financial ratios and details to calculate and fill in the balance sheet values.

given, sales = $3650,000 total asset turn over = 1.6 x total asset turnover = salestotal asset1.6 =3650,000total asset total asset = $2,281,250 total asset = $2,281,250 for balance sheet to balance total asset = total liabilities and equity total liabilities and equity= $2,281,250average collection period = 25 days average collection period = 365×account receivablesales25 =365×account receivable3650,000account receivable =$250,000 account receivable = $250,000 total debt to total asset = total debt to total asset =total debt total asset0.4=total debt 2,281250total debt = $912,500 TOTAL DEBT = $912,500 TOTAL DEBT + EQUITY = 2281250EQUITY = $2281250 - $912500EQUITY = $1,368,750 SHAREHOLDER'S EQUITY = $1368,750 Current liability to networth= 30% networth = shareholder's equity networth = $1368,750 current liability to networth=current liabilitynetworth0.3=current liability1368750current liability = $410,625 TOTAL Current liability = $410,625 IN balance sheet under current liability head only one line item is present and that is account payable. Therefore, TOTAL CURRENT LIABILITY = ACCOUNT PAYABLE ACCOUNT PAYABLE = $410,625Total liability and equity = shareholder's equity + long term debt +total current liabilitylong term debt = total liability and equity -shareholder's equity -total current liability=2281250- 1368750 -410625=$501,875 long term debt = $501,875current ratio = 4:1 current ratio=current asset current liability41=current asset 410,625current asset = $1,642,500 total current asset = $1,642,500 fixed asset = total asset - total current asset fixed asset = 2,281,250-1,642,500=$638,750 fixed asset = $638,750quick ratio = 3:1 quick ratio=current asset - inventorycurrent liability31=$1,642,500 - inventory410,625inventory=$410,625 inventory = $410,625 total current asset = cash + account receivable+ inventory1642500=cash +250,000+410,625cash = $981,875 cash = $981875

Business

Finance

Consider the following data for the Jamestown Company. Sales = $3,650,000 Total asset turnover = 1.6x Current ratio = 4:1 Quick ratio = 3:1 Current liabilities to net worth = 30% Average collection period = 25 days Total debt to total assets = 0.4 Fill in the balance sheet for the Jamestown Company based on the data provided above (assume a 365-day year). Round your answers to the nearest dollar. Balance Sheet Cash 24 Accounts payable 24 Accounts receivable Total current liabilities $ Inventory Long-term debt 2$ Total current assets Stockholders' equity Fixed assets Total assets 2$ Total liabilities and equity 2$

Consider the following data for the Jamestown Company. Sales = $3,650,000 Total asset turnover = 1.6x Current ratio = 4:1 Quick ratio = 3:1 Current liabilities to net worth = 30% Average collection period = 25 days Total debt to total assets = 0.4 Fill in the balance sheet for the Jamestown Company based on the data provided above (assume a 365-day year). Round your answers to the nearest dollar. Balance Sheet Cash 24 Accounts payable 24 Accounts receivable Total current liabilities $ Inventory Long-term debt 2$ Total current assets Stockholders' equity Fixed assets Total assets 2$ Total liabilities and equity 2$

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Related questions

Q: The Core Company had the following assets and liabilities as of December 31: Assets Cash $58,000…

Q: Balance Sheet Cash $2,200 Marketable Securities 16,200 Accounts Receivable 10,000 Total…

Q: Torrid Romance Publishers has total receivables of $2,300.00, which represents 24.00 days’ sales.…

A: Total receivable = $2300.00 Average receivable period = 24 days Turnover = 2300/(365/24) =…

Q: ompared to its peers, Nguyen... a. generates less profit per dollar of shareholders' equity.…

A: The accounting ratios makes the accounting figures or absolute results of the…

Q: Given the following information, compute the current and quick ratios: Cash $ 90,000 Accounts…

A: The Current ratio refers to the liquidity ratio which measures the ability of the company to pay off…

Q: Reproduced below are selected financial data at the end of Year 6 and forecasts for the end of Year…

A: Prepare cash flows statement to calculate the ending cash balance. Working note:

Q: Suppose that you are given the following data for Niles Company : Note: The data and calculations…

A: Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: Given the following information, compute the current and quick ratios: Cash $ 90,000 Accounts…

A: Liquidity ratios: Liquidity means that the ability of the business to pay its short term liabilities…

Q: A company reports the following income statement and balance sheet information for current year: Net…

A: Theory concept: Return on Assets : It tells the net income earned on total assets used by the…

Q: Following are financial statement numbers and ratios for Salsa Incorporated for the year ended…

A: Given, NOPAT = $572.7 NOA = $3460.8 NOPM = 15.9% NOAT = 1.04 Expected revenue growth = 7%

Q: Pritchett Company reported the following year-end data: Cash $ 20,000 Short-term investments…

A: Current ratio and acid-test ratio are the measures that are determined by the entity to know its…

Q: the following information to complete the balance sheet below. Sales is 60 percent, and fixed asset…

A: The financial ratios are very important in analysing the financial health of the company and it…

Q: The financial statements of Neale Corporation include the following information:…

A: According to the rule, we will answer the first three subparts, for the remaining subparts, kindly…

Q: For the year ended December 31, 2019, Settles Inc. earned an ROI of 9.6%. Sales for the year were…

Q: Use the folloiwng information to complete the financial statement as follows Profit margin rtio 20%…

A: Income statement is a statement that helps in determining the income or the profit and loss of a…

Q: Use the formulas you learned about in the previous stage of the problem to answer the following…

A: Ratio analysis is a quantitative method to determine liquidity, operational efficiency, and…

Q: Given the following information, compute the current and quick ratios: Cash $ 120,000 Accounts…

A: current ratio = current assets/ current liabilities = (cash +accounts receivable…

Q: The Griggs Corporation has credit sales of $908,950. Total assets turnover Cash to total assets…

A: Formula to be used: i) Total asset turnover= Sales / Total assets ii) Cash to total assets = Cash /…

Q: Use the given financial information of BAB's Industry below. Average Accounts Receivable P90,000.00…

A: Net Sales = P2,000,000 Gross profit margin = 25% Gross profit = Net Sales x Gross profit margin

Q: Complete the balance sheet and sales information using the following financial data:…

A: Computation:

Q: arry's BBQ had sales revenue for the year of $400 million and net income of $30 million. Total…

A: Return on Asset = This ratio indicates that how a company manage its asset to generate revenue for…

Q: compute the current and quick ratios

A: Liquidity ratio is the ability of the business to pay the amount due as and when they occurs. These…

Q: Use the following information to complete the balance sheet below. Sales are $8.4 million, capital…

A: The balance sheet represents the position held by the company in the industry which helps the users…

Q: Motorola Credit Corporation's annual report: (dollars in millions) $ 307 Net revenue (sales) Net…

A: given information net sales = 307 millions net income = 164 millions total assets = 2225 millions…

Q: he following information is from Dejlah, Inc.s, financial statements. Sales (all credit) were AED…

A: The Balance Sheet shows the values of assets and liabilities of the company at a particular date.

Q: Elizabeth Tailors Inc. has assets of $8,540,000 and turns over its assets 1.8 times per year. Return…

A: A sale is an agreement between a buyer and a seller in which a seller exchanges money in exchange…

Q: Accounts and notes receivable (net) 320,000 Inventories 700,000 Prepaid expenses 40,000 Accounts…

A: ''Since you have asked multiple question, we will solve the first question for you. If you want any…

Q: Given the following information, calculate the debt ratio percentage: Liabilities = $24,500 Liquid…

A: The debt ratio evaluates the financial leverage of an organization. Organizations with more elevated…

Q: Data pertaining to the current position of Lucroy Industries Inc. follow: Cash $430,000 Marketable…

A: Accounting Ratios: The ratios are computed using the financial statement of a company and they…

Q: A firm has the following accounts; current liabilities = $30,000,000, sales = $245,000,000. The firm…

A: Here,CurrentRatio is 1.76 timesInventory Turnover Period is 15.5 timesAverage Collection Period is…

Q: Table 1 shows a balance sheet for a certain company. All quantities shown are in millions of…

A: Net working capital is that amount of capital which is being used in day to day normal operations in…

Q: EMM, Inc. has the following balance sheet: EMM, Incorporated Balance Sheet as of 12/31/X0…

A: 1.If the firm expects sales to rise from $17,000 to $21,000, what are the forecasted levels of…

Question

### Data for Jamestown Company

- **Sales**: $3,650,000
- **Total Asset Turnover**: 1.6x
- **Current Ratio**: 4:1
- **Quick Ratio**: 3:1
- **Current Liabilities to Net Worth**: 30%
- **Average Collection Period**: 25 days
- **Total Debt to Total Assets**: 0.4

### Instructions

Fill in the balance sheet for the Jamestown Company based on the data provided above, assuming a 365-day year. Round your answers to the nearest dollar.

### Balance Sheet Structure

#### Assets

- **Cash**: $ _____
- **Accounts Receivable**: $ _____
- **Inventory**: $ _____
- **Total Current Assets**: $ _____
- **Fixed Assets**: $ _____
- **Total Assets**: $ _____

#### Liabilities and Equity

- **Accounts Payable**: $ _____
- **Total Current Liabilities**: $ _____
- **Long-term Debt**: $ _____
- **Stockholders’ Equity**: $ _____
- **Total Liabilities and Equity**: $ _____

> Use the given financial ratios and details to calculate and fill in the balance sheet values.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Trending now

This is a popular solution!

Step by step

Solved in 7 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data:Total assets turnover: 15×Days sales outstanding: 36.5 daysaInventory turnover ratio: 5×Fixed assets turnover: 3.0×Current ratio: 2.0×Gross profit margin on sales: (Sales − Cost of goods sold)/Sales = 25%aCalculation is based on a 365-day year
Given the following information, compute the current and quick ratios: Cash $ 90,000 Accounts receivable 341,000 Inventory 492,000 Current liabilities 472,000 Long-term debt 617,000 Equity 592,000 Round your answers to two decimal places. Current ratio: :1 Quick ratio: :1
please see attached file
The following information applies to the MO’s Restaurant: ROE 30% Accounts Receivable Turnover 30 times Current Ratio 1.8 to 1 Profit Margin 9% Acid-Test Ratio 1.3 Property and Equipment $1,750,000 Cash and Marketable Securities $55, 000 Total Sales $3,500,000 Assume the following: TA=CA+P&EQ The accounts receivable turnover is based on total sales The balance of balance sheet accounts at the beginning of the year are the same as the end of the year. Required: 1. Total Current Liabilities 2. Total Current Assets 3. Net Income 4. Asset Turnover 5. Total Owner’s Equity 6. Long Term Debt 7. Return on Assets 8. Debt-Equity Ratio 2. Indicate the effects of the transactions listed below on each of the following:…
Crafter Company has the following assets and liabilities: Assets Cash $28,000 Accounts receivable 15,000 Inventory 20,000 Equipment 50,000 Liabilities Current portion of long-term debt $10,000 Accounts payable 2,000 Long-term debt 25,000 Determine the quick ratio (rounded to one decimal point).
Please help me with all answers and show all calculation thanku
You are provided the following working capital information for the Ridge Company: Account Inventory $ $12,890 Accounts receivable 12,800 Accounts payable 12,670 Net sales $124,589 99,630 Cost of goods sold What is the cash conversion cycle for Ridge Company? a. 38.3 days b. 129.9 days c. 83.5 days d. 46.4 days
ss
Consider the following financial data for Terry Enterprises: Balance Sheet as of December 31, 2018 Cash $ 86,000 Accounts payable $ 15,500 Accts. receivable 91,500 Notes payable 93,500 Inventories 65,500 Accruals 19,500 Total current assets $ 243,000 Total current liabilities $ 128,500 Long-term debt 162,500 Net plant & equip. 419,500 Common equity 371,500 Total assets $ 662,500 Total liab. & equity $ 662,500 Statement of Earnings for 2018 Industry Average Ratios Net sales $ 642,500 Current ratio 2.2× Cost of goods sold 482,000 Quick ratio 1.7× Gross profit $ 160,500 Days sales outstanding 44 days Operating expenses 119,500 Inventory turnover 6.7× EBIT $ 41,000 Total asset turnover 0.6× Interest expense 14,500 Net profit margin 7.2% Pre-tax earnings $ 26,500…
Show the current ratio with formulas
Cullumber company has these comparative balance sheet data:
What does the company report for the following accounts for the most current fiscal year: Enter your answer in millions. Total Assets: 70,581 Total Liabilities: 67,282 Long-Term debt: 35,822 Other long-term liabilities: 8,294 Operating Income: 18,278 Interest expense: 1,347 2. The company projects the following for the next fiscal year: • Total assets will increase by 5%.• Total liabilities will increase by 6%.• Long-term debt and interest expense will increase by 7%.• Operating income will increase by $750 million. a. Total assets: 74,100 b Total liabilities: 71,319 c. Long-term debt: 38,330 d. operating income: 19,028 e. Interest expense: Provide the next year’s forecasted balances for the above accounts. Round your answer to the nearest million. 1. Compute the forecasted debt to equity ratio for the next fiscal year. Round your answer to two decimal places. 2. Compute the forecasted long-term debt to equity ratio for the next fiscal year. Round your answer to two decimal…

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS