The following information relates to a company that you are considering investing in. The company has...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The following information relates to a company that you are considering investing in. The company has the following ratios: Current ratio- .90 Inventory to Sales Conversion Period - 160 days Sales to Cash Conversion Period - 55 days Purchases to Payments Conversion Period - 14 days The accountant also reports that the gross profit margin is 18% and the next profit margin is 5%. Now you are being provided with this additional information on the company. The company also has a bank line of credit that allows the company to borrow any shortfall it might have in cash. Interest on the loan is 10%. Assume the loan remains constant throughout the year. The company likes to keep no less than $25,000 in its bank account. Assume that outstanding accounts payable are all related to inventory purchases. The company has $1,200,000 of equity and $140,000 in retained earnings at the end of the year. Sales in the most recent year were $2,600,000. Ignore income tax for purposes of this problem. Build a balance sheet and income statement financial model. What is the company's return on investment? Bonus Points: What changes can managing make that will have the greatest impact on ROI? The following information relates to a company that you are considering investing in. The company has the following ratios: Current ratio- .90 Inventory to Sales Conversion Period - 160 days Sales to Cash Conversion Period - 55 days Purchases to Payments Conversion Period - 14 days The accountant also reports that the gross profit margin is 18% and the next profit margin is 5%. Now you are being provided with this additional information on the company. The company also has a bank line of credit that allows the company to borrow any shortfall it might have in cash. Interest on the loan is 10%. Assume the loan remains constant throughout the year. The company likes to keep no less than $25,000 in its bank account. Assume that outstanding accounts payable are all related to inventory purchases. The company has $1,200,000 of equity and $140,000 in retained earnings at the end of the year. Sales in the most recent year were $2,600,000. Ignore income tax for purposes of this problem. Build a balance sheet and income statement financial model. What is the company's return on investment? Bonus Points: What changes can managing make that will have the greatest impact on ROI?
Expert Answer:
Answer rating: 100% (QA)
To build a balance sheet and income statement financial model well start with the given information and calculate the necessary components Balance Sheet Assets Cash This will be the minimum of 25000 o... View the full answer
Related Book For
Principles Of Financial Accounting
ISBN: 9781118757147
1st Canadian Edition
Authors: Jerry J. Weygandt, Michael J. Atkins, Donald E. Kieso, Paul D. Kimmel, Valerie Ann Kinnear, Barbara Trenholm, Joan E. Barlow
Posted Date:
Students also viewed these finance questions
-
Over 350 students took a college calculus final exam. The scores of the students follow a normal distribution. Using the information given below, determine the mean and the standard deviation for the...
-
9.12 Use Gauss-Jordan elimination to solve: 2x1 + x2x3 =1 5x1 + 2x2 + 2x3 = -4 3x1 + x2 + x3 = 5 Do not employ pivoting. Check your answers by substituting them into the original equations. 10.3 (a)...
-
Wedding cost estimation: Given the following information, calculate the estimated costs for a wedding with 250 guests and a bridal party of six, using the methods indicated. Show your work. Note that...
-
On January 1, 2018, JKJ purchased a 1,000 acre farm with a building. The asking price was $2,600,000. Approximately 15 percent of the total value of the farm was allocable to the building and the...
-
Let f be a flow in a network, and let be a real number. The scalar flow product, denoted f, is a function from V V to R defined by (f)(u, v) = f (u, v). Prove that the flows in a network form a...
-
The figure shows a 400-mm-diameter brake drum with four internally expanding shoes. Each of the hinge pins A and B supports a pair of shoes. The actuating mechanism is to be arranged to produce the...
-
What formula should Hardy Company use to calculate the total amount of interest on a note payable that uses add-on interest?
-
Fultz Company manufactures tablecloths. Sales have grown rapidly over the past 2 years. As a result, the president has installed a budgetary control system for 2010.The following data were used in...
-
Time period Project A () Project B () 0 -100,000 -100,000 1 45,000 20,000 2 60,000 40,000 3 10,000 50,000
-
The Bombay Beverage Company has heavily advertised its social responsibility to the environment and community. In its advertisements, the company touts how its recycling efforts have reduced its...
-
2Vx+1 - 5 is a one-one function O True O False
-
What is a recommended criterion to determine the number of clusters in a k-means approach? a. Silhouette score. b. Elbow method. c. Corresponding set of k clusters has an intuitive interpretation and...
-
What happens to hours of work when the wage rate falls? Decompose the change in hours of work into income and substitution effects.
-
Which of the following statements about hierarchical clustering is true? a. Because of its nested design, hierarchical clustering will find the set of k clusters that maximizes the average silhouette...
-
Which of the following is a true statement about the comparison of Euclidean distance versus Manhattan distance? a. Manhattan distance is distorted less by outlier observations. b. Euclidean distance...
-
Which of the following distance measures is commonly applied to a frequency-document matrix and why? a. Jaccard distancebecause text is expressed as binary variables in a frequencydocument matrix. b....
-
This project focuses on change management. In this element, would like to see more focus on change and change management principles. Question: What are barriers to change in an organization and how...
-
The process of collaborative goal setting by a manager and subordinate, the extent to which goals are accomplished is a major factor in evaluating and rewarding the subordinate's performance. It is...
-
For each of the following statements, indicate whether the statement is true or false by placing a T or an F in the blank at the start of each statement. (a) Canadian publicly accountable enterprises...
-
Eaton Inc. issues a $360,000, 10-year, 6% mortgage note payable on November 30, 2013, to obtain financing for a new building. The terms provide for monthly instalment payments. Prepare the journal...
-
Explain the difference between operating expenditures and capital expenditures during an assets useful life. Which type of account is debited in each case?
-
What is the gamblers fallacy?
-
What are rules of thumb?
-
What is compartmentalizing?
Study smarter with the SolutionInn App