Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi I cannot get my proforma balance sheet balance.If i would like to apply DNF (either borrowing or issue common stock how do i go

Hi

I cannot get my proforma balance sheet balance.If i would like to apply DNF (either borrowing or issue common stock how do i go about it?)

I cannot have a balance total asset and equity. Im not sure where i did wrong

image text in transcribed

Reveale Net Income ASSETS Current assets Inventorie Receivables, deposit and prepayments Deposit, cash and bank balances Total Curent Assets Non-current assets Property, plant and equipment Intangible assets Right of use anser Financial assets at fair value through other comprehensive income (TVOCT") Receivable, deposits an preposent Total You crent assers TOTAL ASSETS EQUITY AND LIABILITIES Current liabilities Provisions for liabilities and charges Pigable and accrusade Amour due to related parties Porrowings Derivative Lucial instels Taxation Equity Sirve Reserves Toral Current Labiries Non-current liabilities Provisions for liabilities and charges Pagable and accmaala Porrowings Derivative financial instants Deferred tax liabilities Total Non-Cuvent Liabilities NET ASSETS TOTAL EQUITY AND LIABILITIES Projected Source of Financing Dicretionary Facing Need Total Financing needs-Total Assets Notes I 2 3 4 5 6 4 7 8 9 10 11 12 13 11 1.5 16 17 18 19 20 9,203.000 1,320,000 Sales or 14% 2821 20125 20124 3,000 6,000 7,200 8.640 1.807,000 2,168,400 2,211,768 2.256,000 1,191,000 1.345,830 1,520,788 1,718,490 3,003,100 3,520,230 3,739.756 3,983,134 20122 137,000 4,055,000 20,000 2,031,000 9.000 19,000 6,274,000 335.000 145,000 8,056,000 1,006,500 913,000 1,107.150 19,440,000 20,013,046 20,607.762 22.443,000 23,533,276 24,347,516 PROFORMA BALANCE SHEET 4.000 2,561,000 4,161,000 6,725,00 5.193.000 5,328,018 5,466,546 5.608.677 5,754.502 5,904,119 6,057,626 6,215.125 11,474,000 11,772,324 12.078,404 12.392,443 12,714,646 13,045,227 13,384,403 13,732.398 1,854,000 1,902,204 1,951,661 2,002,404 2,054,467 2,107,883 2,162,688 2,218,918 4,000 4.000 138,370 139,754 1,176,650 1,301,950 20,000 20,000 2.034,850 2,136.971 9,090 19,380 6,448.340 348,400 149,350 8.257,400 9,181 19,768 6,627,623 0 908,000 9.444,00 0 962,480 1,020,229 9.717,630 10,000.2301 6,725,000 7.367,306 7,719.665 U 2025 4,000 2026 10,368 12,412 2,301,123 2,347,146 1,941,394 2,194,340 4.253.385 4,553,928 4.883,623 0 2027 11,930 17,916 2,394,089 2,441,971 2479,605 2,801,953 1,261,840 362,336 376,829 391.903 407,579 423,882 133.831 158,445 163,199 168,095 173,138 8,463.835 8.675.431 8.892,317 9,114.625 9.342,490 0 6.376,718 6,542 513 14.089,440 14,455.765 2,276,610 2.335,802 4,000 4.000 4,000 4,000 1,217,865 1.339,652 1,473.617 1.620,978 1,781 0176 1,961,384 2.157,522 21,225,389 21,867,267 22,534,846 23,229,696 23,953,517 24,708,152 25,495,602 25.208,523 26,120.653 27,088,774 28,118,319 29,215,356 30.366.668 31,639,841 32,983,367 2,373,274 26,318.040 0 4,000 141,151 142.563 145,428 146.683 20.000 143,968 148,351 4,431,008 1,363,938 1,700,856 1811.882 1,987,139 5,136,753 20.000 20.000 20,000 20,000 20,000 2.190.396 2,213,155 2.301,281 2,338.816 2,117,787 2,178,231 9.273 9,365 9,459 9.554 9.649 9,746 20,163 20,566 20,978 21.397 21,825 22,262 6,811,990 7,001,588 3,196,166 7,397,078 7,603,282 2,615,280 2.667,586 2,720.937 2,775,356 2,830,863 4,269,186 4,380,185 4,494,070 4,610,915 4,730,799 6,831,166 3,047,770 7,315,007 2,336,272 7,561,662 20:28 U 20129 21.199 25,799 2,490,810 2,540,626 3,166,207 3,377,814 3,678,516 6,14-1,239 7,047,770 7,215,007 7.386,272 6,884,466 7,561,662 7,741,280 16.618,810 17,299,718 17,993,516 18,734,381 19.537,112 20,377,039 23,533,276 24,347,518 25.208,523 26,120,653 27,088,774 28,118,319 4.000 0 149.835 5,290,855 20,000 2,340,187 9,843 22,707 7,315,343 8,033,427 440.837 458,471 476.809 17,832 183,682 189,192 9,576,012 9,811,454 10.060,840 0 C 1.081,443 1.146.329 1,215,109 1,288,015 1,365,296 1.447,214 1,534,047 1,626,090 10,292,148 10,393,747 10,905,407 11.227,525 11.560.513 11,904,320 12,260,889 12.629,201 8,104,384 8.525,318 8,986.802 9498,717 10,051,556 10,666,505 11.345,525 12,096.458 0 2,887,180 2.945.230 3.004.135 3,06 1,217 4,853,800 4,979,999 5,109,479 5,242,325 7,211,280 7,925,229 8,113,613 8,306,543 2031 30.959 2,591,439 1.042,930 6,665,327 7,925,229 8,113,613 21,290,127 22,273.051 29,215,356 30.366,668 6,712,618 14,831,615 2,396.533 4.000 151,333 5419,581 20.000 2.603,692 9,942 23,161 8,257,709 495,882 194.868 10,312,361 3,125,502 5,378,626 3.501,127 8.306,543 8,504,127 23.333.798 21,179,2410 31,639,841 32,983,367 Reveale Net Income ASSETS Current assets Inventorie Receivables, deposit and prepayments Deposit, cash and bank balances Total Curent Assets Non-current assets Property, plant and equipment Intangible assets Right of use anser Financial assets at fair value through other comprehensive income (TVOCT") Receivable, deposits an preposent Total You crent assers TOTAL ASSETS EQUITY AND LIABILITIES Current liabilities Provisions for liabilities and charges Pigable and accrusade Amour due to related parties Porrowings Derivative Lucial instels Taxation Equity Sirve Reserves Toral Current Labiries Non-current liabilities Provisions for liabilities and charges Pagable and accmaala Porrowings Derivative financial instants Deferred tax liabilities Total Non-Cuvent Liabilities NET ASSETS TOTAL EQUITY AND LIABILITIES Projected Source of Financing Dicretionary Facing Need Total Financing needs-Total Assets Notes I 2 3 4 5 6 4 7 8 9 10 11 12 13 11 1.5 16 17 18 19 20 9,203.000 1,320,000 Sales or 14% 2821 20125 20124 3,000 6,000 7,200 8.640 1.807,000 2,168,400 2,211,768 2.256,000 1,191,000 1.345,830 1,520,788 1,718,490 3,003,100 3,520,230 3,739.756 3,983,134 20122 137,000 4,055,000 20,000 2,031,000 9.000 19,000 6,274,000 335.000 145,000 8,056,000 1,006,500 913,000 1,107.150 19,440,000 20,013,046 20,607.762 22.443,000 23,533,276 24,347,516 PROFORMA BALANCE SHEET 4.000 2,561,000 4,161,000 6,725,00 5.193.000 5,328,018 5,466,546 5.608.677 5,754.502 5,904,119 6,057,626 6,215.125 11,474,000 11,772,324 12.078,404 12.392,443 12,714,646 13,045,227 13,384,403 13,732.398 1,854,000 1,902,204 1,951,661 2,002,404 2,054,467 2,107,883 2,162,688 2,218,918 4,000 4.000 138,370 139,754 1,176,650 1,301,950 20,000 20,000 2.034,850 2,136.971 9,090 19,380 6,448.340 348,400 149,350 8.257,400 9,181 19,768 6,627,623 0 908,000 9.444,00 0 962,480 1,020,229 9.717,630 10,000.2301 6,725,000 7.367,306 7,719.665 U 2025 4,000 2026 10,368 12,412 2,301,123 2,347,146 1,941,394 2,194,340 4.253.385 4,553,928 4.883,623 0 2027 11,930 17,916 2,394,089 2,441,971 2479,605 2,801,953 1,261,840 362,336 376,829 391.903 407,579 423,882 133.831 158,445 163,199 168,095 173,138 8,463.835 8.675.431 8.892,317 9,114.625 9.342,490 0 6.376,718 6,542 513 14.089,440 14,455.765 2,276,610 2.335,802 4,000 4.000 4,000 4,000 1,217,865 1.339,652 1,473.617 1.620,978 1,781 0176 1,961,384 2.157,522 21,225,389 21,867,267 22,534,846 23,229,696 23,953,517 24,708,152 25,495,602 25.208,523 26,120.653 27,088,774 28,118,319 29,215,356 30.366.668 31,639,841 32,983,367 2,373,274 26,318.040 0 4,000 141,151 142.563 145,428 146.683 20.000 143,968 148,351 4,431,008 1,363,938 1,700,856 1811.882 1,987,139 5,136,753 20.000 20.000 20,000 20,000 20,000 2.190.396 2,213,155 2.301,281 2,338.816 2,117,787 2,178,231 9.273 9,365 9,459 9.554 9.649 9,746 20,163 20,566 20,978 21.397 21,825 22,262 6,811,990 7,001,588 3,196,166 7,397,078 7,603,282 2,615,280 2.667,586 2,720.937 2,775,356 2,830,863 4,269,186 4,380,185 4,494,070 4,610,915 4,730,799 6,831,166 3,047,770 7,315,007 2,336,272 7,561,662 20:28 U 20129 21.199 25,799 2,490,810 2,540,626 3,166,207 3,377,814 3,678,516 6,14-1,239 7,047,770 7,215,007 7.386,272 6,884,466 7,561,662 7,741,280 16.618,810 17,299,718 17,993,516 18,734,381 19.537,112 20,377,039 23,533,276 24,347,518 25.208,523 26,120,653 27,088,774 28,118,319 4.000 0 149.835 5,290,855 20,000 2,340,187 9,843 22,707 7,315,343 8,033,427 440.837 458,471 476.809 17,832 183,682 189,192 9,576,012 9,811,454 10.060,840 0 C 1.081,443 1.146.329 1,215,109 1,288,015 1,365,296 1.447,214 1,534,047 1,626,090 10,292,148 10,393,747 10,905,407 11.227,525 11.560.513 11,904,320 12,260,889 12.629,201 8,104,384 8.525,318 8,986.802 9498,717 10,051,556 10,666,505 11.345,525 12,096.458 0 2,887,180 2.945.230 3.004.135 3,06 1,217 4,853,800 4,979,999 5,109,479 5,242,325 7,211,280 7,925,229 8,113,613 8,306,543 2031 30.959 2,591,439 1.042,930 6,665,327 7,925,229 8,113,613 21,290,127 22,273.051 29,215,356 30.366,668 6,712,618 14,831,615 2,396.533 4.000 151,333 5419,581 20.000 2.603,692 9,942 23,161 8,257,709 495,882 194.868 10,312,361 3,125,502 5,378,626 3.501,127 8.306,543 8,504,127 23.333.798 21,179,2410 31,639,841 32,983,367

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

Step: 3

blur-text-image

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

Principles Of Managerial Finance

Authors: Chad Zutter, Scott Smart

16th Global Edition

1292400641, 978-1292400648

More Books

Students also viewed these Finance questions