Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
Start with the partial model in the file attached. Marvel Pence, CEO of Marvel’s Renovations, a custom building and repair company, is preparing documentation for a line of credit request from his commercial banker. Among the required documents is a detailed sales forecast for parts of 2020 and 2021:
|
|
Sales
|
Labor and Raw Materials
|
|
May, 2020
|
$75,000
|
$80,000
|
|
June, 2020
|
$115,000
|
$75,000
|
|
July, 2020
|
$145,000
|
$105,000
|
|
August, 2020
|
$125,000
|
$85,000
|
|
September, 2020
|
$120,000
|
$65,000
|
|
October, 2020
|
$95,000
|
$70,000
|
|
November, 2020
|
$75,000
|
$30,000
|
|
December, 2020
|
$55,000
|
$35,000
|
|
January, 2021
|
$45,000
|
N/A
|
Estimates obtained from the credit and collection department are as follows: collections within the month of sale, 20%; collections during the month following the sale, 60%; collections the second month following the sale, 25%. Payments for labor and raw materials are typically made during the month following the one in which these costs were incurred. Total costs for labor and raw materials are estimated for each month as shown in the table. General and administrative salaries will amount to approximately $25,000 a month; lease payments under long-term lease contracts will be $7,000 a month; depreciation charges will be $8,000 a month; miscellaneous expenses will be $5,000 a month; income tax payments of $30,000 will be due in both August and December; and a progress payment of $95,000 on a new office suite must be paid in October. Cash on hand on July 1 will amount to $70,000, and a minimum cash balance of $30,000 will be maintained throughout the cash budget period.
b. Prepare an estimate of the required financing (or excess funds)—that is, the amount of money Marvel’s Renovations will need to borrow (or will have available to invest)—for each month during that period.
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
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
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
- i need the answer quicklyarrow_forwardDuring 2020, Pearl Company started a construction job with a contract price of $1,610,000. The job was completed in 2022. The following information is available. 2020 2021 2022 Costs incurred to date $393,900 $760,380 $1,059,000 Estimated costs to complete 616,100 341,620 –0– Billings to date 299,000 905,000 1,610,000 Collections to date 268,000 818,000 1,421,000 Compute the amount of gross profit to be recognized each year, assuming the percentage-of-completion method is used. Gross profit recognized in 2020 $enter a dollar amount Gross profit recognized in 2021 $enter a dollar amount Gross profit recognized in 2022 $enter a dollar amount eTextbook and Media List of Accounts Prepare all necessary journal entries for 2021. (Credit account titles are automatically indented when amount is entered. Do not…arrow_forwardSubject: acountingarrow_forward
- Please help with the COS schedule. I have included an info sheet with all breakdowns. See below if you need this information: Income for January-actual activity based on price levels: For example, if you chose a grooming price of $25 per groom, the actual grooms in January were 4 per day assuming a 30-day month.If you chose. . .The actual # of grooms/daycare/kennelGrooming price $25 4 grooms per dayGrooming price $30 3 grooms per dayGrooming price $35 2 grooms per dayDaycare price $18 22 dogs per dayDaycare price $20 12 dogs per dayDaycare price $25 9 dogs per dayKennel price $25 12 dogs per dayKennel price $28 9 dogs per dayKennel price $30 6 dogs per dayarrow_forwardYou have been presented with the following information by the Budget Committee of the organization in which you work: Sales forecast January – April 2020 Details Study lamps Accent lights Expected selling price per unit $300 $500 Sales Volume forecast: January 2 000 units 1 000 units February 2 500 units 1 500units March 3 000 units 1 000 units April 2 000 units 1 200 units Additional information: (i) Beginning inventories: study lamps 300 units; accent lights 200 units. (ii) The ending inventory for each product at the end of each month is to be maintained at 20% of the budgeted sales for the next month. (iii) To make one study lamp, four (4) units of raw material lumber are used, while five (5) units of raw material aluminum are used to make one accent lights. Required: The Sales Budget for both products for January to March 2020. The Direct Material usage budget.arrow_forwardHelp pleasearrow_forward
- Eliot Sprinkler Systems produces equipment for lawn irrigation. One of the parts used in selected Eliot equipment is a specialty nozzle. The budgeting team is now determining the purchase requirements and monthly cash disbursements for this part. Eliot wishes to have in stock enough nozzles to use for the coming month. On August 1, the company has 16,800 nozzles in stock, although the latest estimate for August production indicates a requirement for only 15,000 nozzles. Total uses of the nozzle are expected to be 14,700 in September and 15,540 in October. Nozzles are purchased at a wholesale price of $8. Eliot pays 25 percent of the purchase price in cash in the month when the parts are delivered. The remaining 75 percent is paid in the following month. Eliot purchased 21,000 parts in July. Required: a. Estimate purchases of the nozzle (in units) for August and September. b. Estimate the cash disbursements for nozzles in August and September.arrow_forwardPhoenix Management helps rental property owners find renters and charges the owners one-half of the first month’s rent for this service. For August 2022, Phoenix expects to find renters for 100 apartments with an average first month’s rent of $760. Budgeted cost data per tenant application for 2022 follow: Professional labor: 2.0 hours at $15.00 per hour Credit checks: $53.00 Phoenix expects other costs, including the lease payment for the building, secretarial help, and utilities, to be $3,600 per month. On average, Phoenix is successful in placing one tenant for every three applicants. Actual rental applications in August 2022 were 270. Phoenix paid $9,300 for 480 hours of professional labor. Credit checks went up to $58 per application. Other costs in August 2022 (lease, secretarial help, and utilities) were $3,900. The average first monthly rentals for August 2022 were $860 per apartment unit for 90 units. Required: 1. (a) What is the master budget variance for August…arrow_forwardDuring 2020, Teal Company started a construction job with a contract price of $1,620,000. The job was completed in 2022. The following information is available. 2020 2021 2022 Costs incurred to date $393,900 $889,380 $1,061,000 Estimated costs to complete 616,100 208,620 -0- Billings to date 303,000 902,000 1,620,000 Collections to date 273,000 814,000 1,418,000 (a) Compute the amount of gross profit to be recognized each year, assuming the percentage-of-completion method is used. Gross profit recognized in 2020 $ Gross profit recognized in 2021 $ Gross profit recognized in 2022 %24 %24arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author: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 ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
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