Question

ABC is a real-estate firm. One of its offices project that Year 2 quarterly sales will...

ABC is a real-estate firm. One of its offices project that Year 2 quarterly sales will increase by 3 percent in Quarter 1, 3 percent in Quarter 2, 5 percent in Quarter 3, and 5 percent in Quarter 4. Management expects total operating expenses to be 85 percent of revenues during each of the first 2 quarters, 86 percent of revenues during the third quarter, and 81 percent during the fourth. The office manager expects to borrow $100,000 on July 1, with quarterly principal payments of $10,000 beginning on September 30 and interest paid at the annual rate of 12 percent. Year 1 last quarter sales were $520,000.

Required:

Prepare a budgeted income statement for each of the 4 quarters of Year 2 and for the entire year. Present the Year 2 budget as follows:  

Quarter 1      Quarter 2      Quarter 3      Quarter 4      Full Year (Year 2)

Homework Answers

Answer #1

If You Have Any Queries Please Do Comment

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Monette Motors is a chain of car dealerships. Sales in the fourth quarter of last year...
Monette Motors is a chain of car dealerships. Sales in the fourth quarter of last year were $4,100,000. Suppose management projects that its current​ year's quarterly sales will increase by 6​% in quarter​ 1, by another 5​% in quarter​ 2, by another 7% in quarter​ 3, and by another 3%in quarter 4. Management expects cost of goods sold to be 45% of revenues every​ quarter, while operating expenses should be 30% of revenues during each of the first two​ quarters,...
2. A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines...
2. A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called “U Fly”, by the following significant model: E(Sales) = 300.5 + 2.37(T) - 4.6Q1 - 6.8Q3 + 8.65Q4 Where E(Sales) is the average sales for each quarter (in millions of dollars), T is a time index defined as 1, 2, 3, …………,20, and 20 represents the first quarter of 2020, Q1 = 1 when in the first quarter, 0 otherwise, Q3 =1 when...
Shocker Corporation's sales budget shows quarterly sales for the next year as follows: Unit sales Quarter...
Shocker Corporation's sales budget shows quarterly sales for the next year as follows: Unit sales Quarter 1 10,000 units Quarter 2 8,000 units Quarter 3 12,000 units Quarter 4 14,000 units Corporation policy is to have a finished goods inventory at the end of each quarter equal to 20% of the next quarter's sales. Budgeted production for the second quarter of the next year would be: 8,000 units 8,800 units 8,400 units 7,200 units
A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called...
A consulting firm estimates the quarterly sales (in millions of dollars) of a Regional Airlines called “U Fly”, by the following significant model: E(Sales) = 300.5 + 2.37(T) - 4.6Q1 - 6.8Q3 + 8.65Q4 Where E(Sales) is the average sales for each quarter (in millions of dollars), T is a time index defined as 1, 2, 3, …………,20, and 20 represents the first quarter of 2020, Q1 = 1 when in the first quarter, 0 otherwise, Q3 =1 when in...
The September 30, 2018 balance sheet of ABC Corporation disclosed the following information relating to its...
The September 30, 2018 balance sheet of ABC Corporation disclosed the following information relating to its receivables: Accounts Receivable (net of $18,000 allowance) $342,000 ABC prepares quarterly financial statements. The following occurred during the fourth quarter of 2018: 1. During the 4th quarter, ABC had credit sales of $2,600,000 and collections on accounts receivable (general) of $2,300,000. Uncollectible accounts totaling $19,000 were written off, and a $2,600 accounts receivable previously written off was collected (not included in the $2,300,000 of...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data: 1. Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter. 2. Cost of goods sold for each quarter is $100,000. 3. Variable selling and administrative expenses for each jacket are 10% sales commission. 4. Fixed selling and administrative (S&A) expenses for the...
Consider the following quarterly time series. ​ Quarter Year 1 Year 2 Year 3 1 923...
Consider the following quarterly time series. ​ Quarter Year 1 Year 2 Year 3 1 923 1,112 1,243 2 1,056 1,156 1,301 3 1,124 1,124 1,254 4 992 1,078 1,198 ​ Use a multiple regression model with dummy variables for quarters 1, 2, and 3 and a time variable. What is your forecast for year 4 quarter 1? Round your answer to one decimal place.
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to...
XYZ Corporation is preparing a master budget for 2018. Sales for the year are expected to total 1,000,000 units. Quarterly sales in units are 20%,25%,30%, and 25% respectively. The sales price is expected to be $50 per unit for the first 3 quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2018 are expected to be 10% higher than the budgeted sales volume for the first quarter of 2017. Cash collections from sales...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data: 1. Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter. 2. Cost of goods sold for each quarter is $100,000. 3. Variable selling and administrative expenses for each jacket are 10% sales commission. 4. Fixed selling and administrative (S&A) expenses for the...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a...
Herald company, a jacket selling company, prepares its master budget for the year 2020 on a quarterly basis. The budget officer has gathered the following data: 1. Estimated Sales for each quarter is $230,000. All sales are on credit and all sales are collected in the following quarter. 2. Cost of goods sold for each quarter is $100,000. 3. Variable selling and administrative expenses for each jacket are 10% sales commission. 4. Fixed selling and administrative (S&A) expenses for the...