User Account

All Pages

Problem - Forecasted Statements and Ratios

Assignment Help Financial Accounting
Reference no: EM132461422

Problem - Forecasted Statements and Ratios

Upton Computers makes bulk purchases of small computers, stocks them in conveniently located warehouses, ships them to its chain of retail stores, and has a staff to advise customers and help them set up their new computers. Upton's balance sheet as of December 31, 2016, is shown here (millions of dollars):

Cash $3.5

Accounts payable $9.0

Receivables 26.0

Notes payable 18.0

Inventories 58.0

Line of credit 0

Total current assets $87.5

Accruals 8.5

Net fixed assets 35.0

Total current liabilities $35.5

Mortgage loan 6.0

Common stock 15.0

Retained earnings 66.0

Total assets $122.5

Total liabilities and equity $122.5

Sales for 2016 were $300 million and net income for the year was $9 million, so the firm's profit margin was 3.0%. Upton paid dividends of $3.6 million to common stockholders, so its payout ratio was 40%. Its tax rate was 40%, and it operated at full capacity. Assume that all assets/sales ratios, (spontaneous liabilities)/sales ratios, the profit margin, and the payout ratio remain constant in 2017. Do not round intermediate calculations.

Required -

1. If sales are projected to increase by $80 million, or 26.67%, during 2017, use the AFN equation to determine Upton's projected external capital requirements. Enter your answer in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answer to two decimal places.

2. Using the AFN equation, determine Upton's self-supporting growth rate. That is, what is the maximum growth rate the firm can achieve without having to employ nonspontaneous external funds? Round your answer to two decimal places.

3. Use the forecasted financial statement method to forecast Upton's balance sheet for December 31, 2017. Assume that all additional external capital is raised as a line of credit at the end of the year and is reflected (because the debt is added at the end of the year, there will be no additional interest expense due to the new debt). Assume Upton's profit margin and dividend payout ratio will be the same in 2017 as they were in 2016. What is the amount of the line of credit reported on the 2017 forecasted balance sheets?

Reference no: EM132461422

Questions Cloud

Write down pierre budget constraint : Write down Pierre's budget constraint. Explain how Pierre should determine consumption and leisure in order to maximize utility.
Indebtedness against the indebtedness of the eu countries : Comparing the U.S. indebtedness against the indebtedness of the E.U countries, and of other O.E.C.D countries, reflect on the pertinent issues and concerns.
Calculate the issue price of the bonds : Interest payments are made semi-annually. The market rate for this type of bond is 5%. Using present value tables, calculate the issue price of the bonds
Expectation final value of the house minus payment : You are risk-neutral and care only about the expectation final value of the house minus payment to the contractor, w. That is, your expected utility is uY
Problem - Forecasted Statements and Ratios : Problem - Forecasted Statements and Ratios. During 2017, use the AFN equation to determine Upton's projected external capital requirements
What was the issue price of the bonds : For bonds of similar risk and maturity the market yield is 15%. What was the issue price of the bonds? The bonds mature in 2031 (10 years)
Prepare a report comparing actual to budget : Prepare a report comparing Actual to Budget Year-to-date figures to disclose relevant variances for revenue and cost items and to signify whether the variance
Series of prophecies by the god apollo : According to Roman legend, a series of prophecies by the god Apollo were written down in nine books and interpreted by the Sibyl of Cumae
Inherent features of capitalism : National deficits are inherent features of capitalism which sustain the global system of capital", How does this reflect on impact of immigrants

Reviews

Write a Review

Financial Accounting Questions & Answers

  Income statements for each year using absorption costing

Coswell Company produces plastic that is used for injection-molding applications such as gears for small motors. In 2011, the first year of operations, Coswell produced 4,300 tons of plastic and sold 3,440 tons. In 2012, the production and sales resu..

  Cost basis of the go-cart track for depreciation purposes

You pay $700,000 for a house and the land that it is on. The land is valued at $270,000 and the house is valued at $430,000. You decide to demolish the house ($30,000 demolition cost) and build a go-cart track at a cost of $750,000. What is the cost ..

  Prepare the journal entry for current tax payable

Calculate taxable income and prepare the journal entry for current tax payable (the tax rate is 30%) as at 30th June 2014.

  Compute the gain or loss and refunding transaction

Linda Day George Company had bonds outstanding with a maturity value of $452,900. On April 30, 2014, when these bonds had an unamortized discount of $14,100, they were called in at 105. Ignoring interest, record this refunding transaction. Ignoring i..

  Accounting entries from the given information

Accounting entries from the given information - COLO COMPANY Sales Journal

  Amount of income from loan

The repayments yield an effective interest rate of 11% at a present value of $200,000 and 12.4% at a present value of $194,000.

  Implement a first-order continuum model

Discuss the effect of the different traffic loading patterns on the queue length and the time it takes for the queue

  Calculate the value of each investment

Calculate the value of each investment based on the required rate of return. Which investment would you recommend and why? Research on the current trends and future prospects on each of the industries and include a summary

  Cash flow from operating activities

A company has Net Income of $20, which included $4 of depreciation expense. There were no other noncash expenses in Net Income and there were no gains or losses. Accounts receivable was $40 at the beginning of the year and $25 at the end of the year.

  Requires equal payments of principal plus accrued interest

On August 1, a $30,000, 6%, 3-year installment note payable is issued by a company. The note requires equal payments of principal plus accrued interest be paid each year on July 31. The present value of an annuity factor for 3 years at 6% is 2.6730. ..

  Receives the benefit of the income must pay tax on income

As a general rule, the person who receives the benefit of the income must pay the tax on the income. As a general rule, property is taxed to the person who owns the property. As a general rule, income from services is taxed to the person who earns th..

  How is the federal withholding tax on this payment

Jean received a commission of $7,000 from her employer. How is the federal withholding tax on this payment calculated if she also earns semi monthly wages of $3,500?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd