Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Jul 23, 2024

Please help me calculate and fill the blank. This homework need to conculate the budget and based on the note 1 to note 6. Thank

Please help me calculate and fill the blank. This homework need to conculate the budget and based on the note 1 to note 6. Thank you.

FY-17 100,000,000 Q1-18 Q2-18 03-18 04-18 FY-18 3 Revenue 4 Sequential Growth 5.0% 5.0% 7.5% 10.0% 100.0% YoY Growth 6 Cost of Sales 90,000,000 8 Gross Profit 9 Grass Margin 10 Increase from Base Line FY-2017 10,000,000 10.00% 10.05% 10.125% 10.15% 10.15% #01 bps 12.5 bps 15 bps 15 bps 12 Operating Expense 13 Payroll Expenses 14 Payroll Taxes & Benefits (Load) 5 Sales & Marketing Expenses 16 Other General & Administrative Expenses 17 Depreciation 18Total Operating Expenses 19 | 96 20 21 Operating Profit 22 Operating Margin 23 24 Interest Income 25 Interest Expenses 26 27 Profit Before Tax 28 PBT% 29 30 | Income Tax Expense (28%) 31 32 Net Income 33 Net Marein 3,000,000 600,000 2,500,000 1,500,000 100,000 7,700,000 7.70% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/01 2,300,000 2.30% #DIV/0! #DIV/01 #DIV/01 #DIV/01 ADIV/01 625 (500,000) 1,800,625 1.80% #DIV/0 ! #DIV/01 #DIV/01 #DIV/0! #DIV/0 504,175 1,296,450 1.30% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! FY-17 100,000,000 Q1-18 Q2-18 03-18 04-18 FY-18 3 Revenue 4 Sequential Growth 5.0% 5.0% 7.5% 10.0% 100.0% YoY Growth 6 Cost of Sales 90,000,000 8 Gross Profit 9 Grass Margin 10 Increase from Base Line FY-2017 10,000,000 10.00% 10.05% 10.125% 10.15% 10.15% #01 bps 12.5 bps 15 bps 15 bps 12 Operating Expense 13 Payroll Expenses 14 Payroll Taxes & Benefits (Load) 5 Sales & Marketing Expenses 16 Other General & Administrative Expenses 17 Depreciation 18Total Operating Expenses 19 | 96 20 21 Operating Profit 22 Operating Margin 23 24 Interest Income 25 Interest Expenses 26 27 Profit Before Tax 28 PBT% 29 30 | Income Tax Expense (28%) 31 32 Net Income 33 Net Marein 3,000,000 600,000 2,500,000 1,500,000 100,000 7,700,000 7.70% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/01 2,300,000 2.30% #DIV/0! #DIV/01 #DIV/01 #DIV/01 ADIV/01 625 (500,000) 1,800,625 1.80% #DIV/0 ! #DIV/01 #DIV/01 #DIV/0! #DIV/0 504,175 1,296,450 1.30% #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0

Step by Step Solution

There are 3 Steps involved in it

Step: 1

Get Instant Access with AI-Powered Solutions

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

Step: 2

Step: 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions

Question

=+3. Do movies of different types have different rates of return on their budgets? Heres a scatterplot of Gross Revenue in US ($M) vs. Budget ($M) for recent movies whose MPAA Rating is either PG...

Answered: 1 week ago

Question

★★★★★

Ellynn Kole is the assistant chief accountant at Doman Company, a manufacturer of computer chips and cellular phones. The company presently has total sales of $20 million. It is the end of the first...

Answered: 1 week ago

Question

★★★★★

Journalize entries related to bank reconciliation and all adjusting entries. (Credit account titles are automatically indented when the amount is entered. Do not indent manually. If no entry is...

Answered: 1 week ago

Question

★★★★★

5 10 points eBook Amber Mining and Milling, Incorporated, contracted with Truax Corporation to have constructed a custom-made lathe. The machine was completed and ready for use on January 1, 2024....

Answered: 1 week ago

Question

★★★★★

Describe in detail the three main assumptions for parametric testing.

Answered: 1 week ago

Question

★★★★★

Which information is required to calculate the Total Amount of Insurance Needed in the Financial Needs Analysis (FNA) section? i. Death Amount, Passive Income, Mortgage Balance ii. Mortgage Balance,...

Answered: 1 week ago

Question

★★★★★

An electronic store sells particular model of a laptop computer. There are only six laptops in stock, and the manager wonders what daily demand for this particular model will be. She learns from the...

Answered: 1 week ago

Question

★★★★★

Suppose that, in each period, the cost of a security either goes up by a factor of u = 2 or down by a factor d = 1/2. Assume the initial price of the security is $100 and that the interest rate r is...

Answered: 1 week ago

Question

★★★★★

Sarik was surprised by how many conversations it took to make a deal with CorpCo. What pitfall did Sarik experience?

Answered: 1 week ago

Previous Question Next Question