Interview challenge Pyramidia Ventures

Interview challenge

Pyramidia Ventures
Interview Challenge – Accounting
Admin & Accounting Intern
Prepare the following challenge and send your report in Excel to [email protected]
You are the Accounts Assistant of Pyramidia Ventues Ltd. You are tasked with preparing the periodic Financial Statements.
In any cases where the information is incomplete (indicated with a ?), you’ll have to make and cite your assumptions explicitly.
1. Prepare 12-months of monthly financials, from July 2023 to June 2024.
2. Prepare an Income statement for the year and Opening and Closing Balance sheet for the end of June 2024.
The below information is available. Highlight any concerns or comments
ItemItems as of July 2023%Assumptions
Sales of TomatoesKsh800,000Growing at 5% per month
Sales of Leafy GreensKsh500,000Growing at 8% per month
Rent of sales branchesKsh10,000Constant monthly
SalariesKsh150,000Growing by 5,000 every month
Sales & Marketing costKsh80,000Growing the same as sales volume growth
Other adminKsh40,000Growing at 2% monthly
Gross Margin on Tomatoes26%As of January, GM improves to 28%
Gross Margin on Leafy Greens24%As of January, GM improves to 26%
Long-term bank debtKsh5,000,0005-year term loan with annual principal repayment in January
Interest on debt?Payable monthly. Please suggest interest rate
Purchase of new car?Buy 1 small car in the coming year. Please suggest price and how to finance
Electricity and waterKsh15,0002%Monthly bill, rising at 2% per month
Current assetsKsh3,400,000
Current liabilitiesKsh500,000
Property, plant & equipmentKsh6,000,000
Accumulated depreciationKsh900,000
Financial year depreciationKsh300,000
Stockholder equityKsh3,000,000

&”Calibri,Regular”&K000000&T_x000D_&D &”Calibri,Regular”&K000000Confidential_x000D_&F &”Calibri,Regular”&K000000Page &P _x000D_of &N


Share This Post


Order a Similar Paper and get 15% Discount on your First Order

Related Questions