Homework Answers
inorder to find the required date we need to do financial analysis i.e. calculation ratios and through current quarter outputs calculation of trends in sales and other items so please mention the method you want me to follow
eg the 1st quarter gp ratio is around 17.92%
so gp for the year would be 2652(sales of 2007)*17.92% = 475
Add Answer to:
Please generate an income statement and balance sheet. 2007 is
projected to have net sales of...
Please generate an income and balance sheet for 2007. 2007 is projected to have net sales...
Please generate an income and balance sheet for 2007. 2007 is
projected to have net sales of 2.7 million
4179 Jones Electrical Distribution Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006, and for First Quarter 2007 (thousands of dollars) 2004 2005 2006 Net sales Cost of goods sold Gross profit on sales $ 2.242 $ 1,818 $1,624 $ 1,304 $_320 $ 272 First Quarter 2007 $ 608 $ 499 $ 102 $ 1,916 $1,535 $ 381 $ 307...
Q2: How large of a loan would be needed by year end 2007 to allow Jones...
Q2: How large of a loan would be needed by year end
2007 to allow Jones Electrical to take advantage of the discount
offered by his suppliers? Consider the impact of these discounts on
COGS and Inventory as well. You can assume dividends are $0.
Note: This problem requires Excel to iterate circular references OR
use goal seek.
Q3: Should Jones try to
increase their access to debt financing given the price discount
offered?
HINT: Try to figure...
Please read the facts of the case and prepare answers for the following questions : 1...
Please read the facts of the case and prepare answers for the
following questions :
1 – What is the relevance of the $2,000 monthly payment
to Dave Verden on the analysis of Jones’ financing needs?
2 – What metrics could you use to compare the historical financial
results for Jones with the projected financial results under the
four defined scenarios?
3 – Other than financing needs, what other issues should Jones
address as he considers the different growth
scenarios?...
Read below and answer, Why does a business that has profit of $30,000 per year need...
Read below and answer, Why does a business that has profit of
$30,000 per year need a bank loan?
Jones Electrical Distribution After several years of rapid growth, in the spring of 2007 Jones Electrical Distribution anticipated a further substantial increase in sales. Despite good profits, the company had experienced a shortage of cash and had found it necessary to increase its borrowing from Metropolitan Bank-a local one- branch bank-to $250,000 in 2006. The maximum loan that Metropolitan would make...
Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518...
Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,932 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,808 33,316 29,848 3,405 2,210 1,976 Other income (expenses), net (449) (121) 43 Operating profit 2,956 2,089 2,019 Interest expense 370 425 487 Earnings before taxes 2,586 1,664 1,532 Income tax expense 761 368 479 Net...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended (5 millions) 2007 2006 2005 Sales $ 57,878 $ 51,271 $ 45,682 Credit card revenues 1,612 1,349 1,157 Total revenues 59,490 52,620 46,839 Cost of sales 39,399 34,927 31,445 Selling, general and administrative expenses 12,819 11,185 9,797 Credit card expenses 707 776 737 Depreciation and amortization 1,496 1,409 1,259 Earnings before interest and income taxes 5,069 4,323 3,601 Net interest...
Freiman Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year...
Freiman Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: $ 174 $ 134 Cash Accounts receivable, net 255 275 Inventory 134 144 Prepaid expenses 47 47 Total current assets 600 610 Plant and equipment, net 770 770 $1,380 $1,370 Total assets Liabilities and Stockholders' Equity Current liabilities: 144 164 Accounts payable Accrued liabilities 97 97 Notes payable, short...
Balance sheets and income statements for Target Corporation follow Income Statement For Fiscal Years Ended (5...
Balance sheets and income statements for Target Corporation follow Income Statement For Fiscal Years Ended (5 millions) 2006 2005 2004 Sales $51,271 $ 45,682 $ 40,928 Credit card revenues 1,349 1,157 1,097 Total revenues 52,620 46,839 42,025 Cost of sales 34,927 31,445 28,389 Selling, general and administrative expenses 11,185 9,797 8,657 Credit card expenses 737 722 Depreciation and amortization 1,409 1,259 1,098 Earnings before interest and income taxes 4,323 3,601 3,159 Net interest expense 463 570 556 Earnings before income...
need to make statement if cash flows from this information Panera Bread Co. 1. Use Excel...
need to make statement if cash flows from this
information
Panera Bread Co. 1. Use Excel to compile Indirect Statement of Cash Flows, Common-Size Income Statement and Financial Ratios for each year. Exhibit 1 Panera Bread Company Historic Income Statements (in thousands of dollars) 2003 2004 2005 2006 Number of bakery-cafés 602 741 877 1,027 363,702 479,139 640,275 828,971 Revenue Costs of goods sold Bakery-café Dough sold to franchisees Depreciation General and administrativell) 210,822 54,967 18,304 31,502 315,595 288,706 65,627...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for...
Compute and Interpret Liquidity, Solvency and Coverage Ratios Selected balance sheet and income statement information for Calpine Corporation for 2004 and 2006 follows. ($ millions) 2004 2006 Cash $ 1,256.73 $ 1,523.36 Accounts receivable 1,097.16 735.30 Current assets 3,313.56 3,268.33 Current liabilities 3,285.39 6,057.95 Long-term debt 17,150.81 3,531.63 Short-term debt 1,033.96 4,568.83 Total liabilities 22,898.42 25,503.17 Interest expense 1,516.90 1,288.29 Capital expenditures 1,545.48 211.50 Equity 4,587.67 (7,152.90) Cash from operations 19.89 335.98 Earnings before interest and taxes 1,659.84 1,907.84 (a)...
Please generate an income and balance sheet for 2007. 2007 is
projected to have net sales of 2.7 million
4179 Jones Electrical Distribution Exhibit 1 Operating Statements for Years Ending December 31, 2004-2006, and for First Quarter 2007 (thousands of dollars) 2004 2005 2006 Net sales Cost of goods sold Gross profit on sales $ 2.242 $ 1,818 $1,624 $ 1,304 $_320 $ 272 First Quarter 2007 $ 608 $ 499 $ 102 $ 1,916 $1,535 $ 381 $ 307...
Q2: How large of a loan would be needed by year end
2007 to allow Jones Electrical to take advantage of the discount
offered by his suppliers? Consider the impact of these discounts on
COGS and Inventory as well. You can assume dividends are $0.
Note: This problem requires Excel to iterate circular references OR
use goal seek.
Q3: Should Jones try to
increase their access to debt financing given the price discount
offered?
HINT: Try to figure...
Please read the facts of the case and prepare answers for the
following questions :
1 – What is the relevance of the $2,000 monthly payment
to Dave Verden on the analysis of Jones’ financing needs?
2 – What metrics could you use to compare the historical financial
results for Jones with the projected financial results under the
four defined scenarios?
3 – Other than financing needs, what other issues should Jones
address as he considers the different growth
scenarios?...
Read below and answer, Why does a business that has profit of
$30,000 per year need a bank loan?
Jones Electrical Distribution After several years of rapid growth, in the spring of 2007 Jones Electrical Distribution anticipated a further substantial increase in sales. Despite good profits, the company had experienced a shortage of cash and had found it necessary to increase its borrowing from Metropolitan Bank-a local one- branch bank-to $250,000 in 2006. The maximum loan that Metropolitan would make...
Analysis and Interpretation of Profitability Balance sheets and income statements for Target Corporation follow. Income Statement For Fiscal Years Ended (5 millions) 2007 2006 2005 Sales $ 57,878 $ 51,271 $ 45,682 Credit card revenues 1,612 1,349 1,157 Total revenues 59,490 52,620 46,839 Cost of sales 39,399 34,927 31,445 Selling, general and administrative expenses 12,819 11,185 9,797 Credit card expenses 707 776 737 Depreciation and amortization 1,496 1,409 1,259 Earnings before interest and income taxes 5,069 4,323 3,601 Net interest...
Freiman Corporation's most recent balance sheet and income statement appear below: Balance Sheet December 31, Year 2 and Year 1 (in thousands of dollars) Year 2 Year 1 Assets Current assets: $ 174 $ 134 Cash Accounts receivable, net 255 275 Inventory 134 144 Prepaid expenses 47 47 Total current assets 600 610 Plant and equipment, net 770 770 $1,380 $1,370 Total assets Liabilities and Stockholders' Equity Current liabilities: 144 164 Accounts payable Accrued liabilities 97 97 Notes payable, short...
Balance sheets and income statements for Target Corporation follow Income Statement For Fiscal Years Ended (5 millions) 2006 2005 2004 Sales $51,271 $ 45,682 $ 40,928 Credit card revenues 1,349 1,157 1,097 Total revenues 52,620 46,839 42,025 Cost of sales 34,927 31,445 28,389 Selling, general and administrative expenses 11,185 9,797 8,657 Credit card expenses 737 722 Depreciation and amortization 1,409 1,259 1,098 Earnings before interest and income taxes 4,323 3,601 3,159 Net interest expense 463 570 556 Earnings before income...
need to make statement if cash flows from this
information
Panera Bread Co. 1. Use Excel to compile Indirect Statement of Cash Flows, Common-Size Income Statement and Financial Ratios for each year. Exhibit 1 Panera Bread Company Historic Income Statements (in thousands of dollars) 2003 2004 2005 2006 Number of bakery-cafés 602 741 877 1,027 363,702 479,139 640,275 828,971 Revenue Costs of goods sold Bakery-café Dough sold to franchisees Depreciation General and administrativell) 210,822 54,967 18,304 31,502 315,595 288,706 65,627...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago