University | Nanyang Technological University (NTU) |
Subject | BU8201 Business finance Assignment |
BU8201 Business finance Assignment, NTU, Singapore: Itacho Sushi Restaurant Holding is one of the leading Japanese restaurant groups in Singapore
Question 3 (25 marks) – Financial Planning
Itacho Sushi Restaurant Holding is one of the leading Japanese restaurant groups in Singapore.
By referring to the Group’s Consolidated Profit & Loss Statement for the year ended 30 June 2022 given on Page 8, prepare a Pro Forma Consolidated Profit & Loss Statement for the Year Ended 30 June 2023 with the following assumptions:
-
- Revenue increases by FG% from 2022 where FG are the 6th and 7th digit of the group leader’s administration number.
For example:
- If group leader’s admin. number is 2134567A, revenue increases by 67%.
- If the group leader’s admin. number is 2132008J, revenue increases by 8%.
- If the 6th and 7th digits of the group leader’s admin number are both 0 (e.g. 2134500J), revenue increases by 18%.
- Cost of sales and other operating expenses are variable costs and vary proportionately
with revenue.
- Selling & distribution (S&D) expenses consist of fixed and variable costs. $AB,CDE,000 of the total S&D expenses reported for the year ended 30 June 2022 are fixed costs and the remaining are variable costs where ABCDE are the 1st to 5th digits of the group leader’s admin. number.
Stuck with a lot of homework assignments and feeling stressed ? Take professional academic assistance & Get 100% Plagiarism free papers
For example:
o If group leader’s admin. number is 2134567A, the fixed costs for S&D are $21,345,000.
- General & administrative (G&A) expenses consist of fixed and variable costs. Of the total G&A expenses reported for the year ended 30 June 2022, $4,800,000 are fixed costs and the remaining are variable costs.
- 2023 Tax rate remains the same as in 2022.
- All other income items and expense items are unchanged (in $ amount) for 2023.
Required:
Use the template provided on Page 9 to prepare the Pro Forma Profit & Loss Statement for the year ended 30 June 2023. Reference the workings on the third column in this template using small letters (a, b, c ….).
Show all workings clearly in the space provided on page 9 and the indicate the reference letters based on what you have indicated on the third column provided on Page 8.
For calculation of variable cost %, use up to 1 decimal place (for example: 4.5%)
Consolidated Profit & Loss Statement | Reported |
for the year ended | 30-Jun-22 |
$’000 | |
Revenue | 136,826.0 |
Cost of sales | (21,294.0) |
Gross profit | 115,532.0 |
Add/(Deduct) : Others | |
Interest income | 1,524.0 |
Other gain / (losses) | (1,958.0) |
Less: Operating Expenses | |
Selling & distribution | (100,520.0) |
Fixed costs ($AB,CDE,000) | ? |
Variable costs | ? |
General & administrative | (6,516.0) |
Fixed ($4,800,000) | ? |
Variable | ? |
Other operating expenses | (4,582.0) |
Share of profit of associate co. | (684.0) |
Net profit before tax | 2,796.0 |
Less: Income tax expense | (475.3) |
Net profit | 2,320.7 |
b. Calculate the % change in the net profit from 30 June 2022 to 30 June
Explain the reason(s) for the difference in the % change in the revenue and the % change in the net profit from 2022 and 2023. Is the difference always favourable?
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Start your journey to success in BU8201 Business Finance by looking into our premier Dissertation Writing Services in Singapore. Singapore students can invest in expert support, complemented by our reliable Assignment Helper, paving a distinctive path towards academic excellence marked by expertise and comprehensive assistance in finance assignments and dissertations.
Tags:-
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT