Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve using excel format and give thorough WORK WITH GROUP TO COMPLETE A GROUP BUDGET YOUR COMPANY HAME has applied for a loan. Its

please solve using excel format and give thorough
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
WORK WITH GROUP TO COMPLETE A GROUP BUDGET YOUR COMPANY HAME has applied for a loan. Its bank has requested a 12-month budget and Pro Forma Financials from April 30, 2025 through March 31, 2026. YOUR COMPANY'S Balance Sheet for the Month Ended March 31, 2025 is: BUDGETED BALANCE SHEET Current Assets: Mar-25 Cash 30,000 Accounts Receivable 12,000 Merchandise Inventory 6,000 48,000 TOTAL CURRENT ASSETS Property, Plant, & Equipment Equipment & Fixtures 48,000 Acc. Dep. - Equipment & Fixtures (8,000) TOTAL P,P,E 40,000 TOTAL ASSETS 88,000 BUDGETED BALANCE SHEET Current liabilities Mar-25 Accounts Payable 8,300 Salaries Payable (if needed) Line of Credit Notes Payable, Current Portion (if needed) TOTAL CURRENT LIABILITIES Long-Term Liabilities 8,300 N/P- Long-Term Portion (if needed) TOTALL/T LIABILITIES TOTAL LIABILITIES Stockholder's Equity 8,300 Common Stock 20,000 Retained Earnings 59.700 TOTAL SE 79,700 TOTAL LIABILITIES & SE 88,000 APRIL SALES BUDGET: 600 UNITS @ AVG. SELLS PER OF $80. FUTURE MONTHS SALES (Increases/(Decreases)) % from the Previous Month's Sales: May 2% increase from April, June 3% increase from May, July 1% increase from June, August 1% increase from July. September 1% increase from August, October -1% decrease from September, November 0% increase from October, December 2% increase from November, January 2026 -1% decrease from December, February 0% increase from January, March 1% increase from February, April 2% from March 60% CASH SALE AND 40% SALES ON ACCOUNT paid off next month CONAMENT COMPANY MECHANOS COMPANY SALES LAGPENITH PO TOTAL M ht Attest New Me BO THEOLOR LORES TEMI TOTALITER ODO TOTALE 1 003 Once you can How relec OD NAMI PUNTING COMPANY MERCHANDISING COMPANY SALES TIRE! SALES PER MONTH L. THOSH TOTALS 400 RSS Alex Code Next Mos Gerson both. Cashflow 400 12th young budget WOLDHAVE the Monde 14 MONTHLYURT ASPETT TOTAL SALES H 0000 40 TOTAL On Camalown for at Then how y the D Sep-25 Oot-25 Nov-25 Dec-25 Jan-26 Feb-261 Mar 26 Apr-26 Dec-251 $ Feb-28 Sep-25 Oot-25 Nov-25 Jan-26 Mar 26 Apr-26 Credit Sales for Year TOTAL UNITS FOR YR TOTAL UNITS CO.NAME PRINTING COMPANY (MERCHANDISING COMPANY) ISBUDGET M Man Ah A 2 M A Sep up NO Cash Coll WS Mesh 1920 This would be in a WOULD HAVE Ningbed of Sales trois MORE MONTHLY UNITS MVG SELLS PER UNIT TOTAL SALES 100 000 48.000 5 DO Once you use Cath Coll calculation for local Sales The one to the publices and only seen asures how the numbers were calculated R 5 Sep-25 Sep-25 Oct-25 Oct-25 Nov 25 Nov-25 Dec-25 Dec-25 Jan 26 Jan-26 Feb-26 Feb-26 Mar 26 Mar 26 Apr-26 Apr 26 Credit Sales for Year TOTAL UNITS FOR Y. F TOTAL UNITS +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting An Introduction to Concepts, Methods and Uses

Authors: Roman L. Weil, Katherine Schipper, Jennifer Francis

14th edition

978-1111823450, 1-133-36617-1 , 1111823456, 978-1-133-3661, 978-1133591023

More Books

Students also viewed these Accounting questions